Hello!
I have tried to create a text box that retrieves a name from a table based on what the user types into another text box.
For example, the user types in their first name into a text box called txtFirstName. Another textbox below it returns their surname using a DLookUp function (which searches in the Users table for a surname corresponding to the firstname previously typed in by the user):
=DLookUp("Surname"; "Users"; "FirstName=[Forms]![frmUser]![txtFirstName])
I have tried the function but it is not working (I may not know how to specify that the firstname entered by the user should be the same as the one in the table). I have also tried:
=DLookUp("Surname"; "Users"; "Firstname=" & [Forms]![frmUser]![Firstname])
However, neither works. Can anyone see what I did wrong? And does anyone know another alternative? Help would be greatly appreaciated!