If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DLookup returns same name
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. |
Thread Tools | |
Display Modes | |
|
|