DLookup returns same name
I am not sure what you mean. I scroll throught the conrtact forms and the
Solicitor ID field updates as I do but the name (Dlookup value) is always
that of Solicitor ID 1.
"KARL DEWEY" wrote:
I do believe you must requery when you change the solicitor's ID is on the
form.
--
Build a little, test a little.
"Wordwonderor" wrote:
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
solicitor.
I also have a Contacts form for displaying the contact information. On the
form, I would like to display the solicitor's name from the table called
Solicitor, where the Solicitor ID is the key field. To do this I have a text
box on the Contacts form with the following control:
=DLookUp("[Lname]","[Solicitor]","[Solicitor ID]=Forms![Contacts]![Solicitor
ID]")
But, when run, the name of only one solicitor is displayed regardless of
which solicitor's ID is on the form. I've tried using the " & format after
the = sign in the formula and using just [Solicitor ID]. I still get the same
name and, in addition, a #name error when a record has no solcitor ID. The
name I get is that of Solicitor ID 1.
Help, please.
|