I've changed to a combo box. It seems to work. But I'd like to understand why
the DLook up didn't, as that approach sem to be more direct.

The Solicitor ID is a number field in the form's record source. It is tied
to the Contacts ID.

"BruceM via AccessMonster.com" wrote:

Actually, I realize now that you did mention this, but I misunderstood the
problem. Is SolicitorID a number field? Is the Solicitor text box bound to
LName in the form's Record Source?

Wordwonderor wrote:
Thank you, but it didn't help. The Solicitor ID control is on the form and it
updates as I scroll though the Contacts. But the Solicitor's name field (the
dlookup) doesn't. It always shows the solicitor with Solicitor ID 1.

In an Access 2003 database, I have a form, Contacts, based on a Contacts
table that includes potential donors and the Solicitor ID of their assigned
[quoted text clipped - 26 lines]
This does assume that there is a control named [Soliciter ID] on the form,
which contains the desired ID.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1

.