Auto Populate two fields

[funkygoorilla]

Hi, question on auto populating.


I have a form where a user needs to enter a ID number, and I have a table of ID numbers and the Names that they go with. I would like for the user to enter the ID number and in separate fields, the form will display the last name and first name. I dont need the information stored, I am just wanting to use it as a way for the user to verify they typed in the correct ID. Is this done with a query? Or can someone recommend a solution.
Thanks!
FunkyG

[pbaldy]

Does this help?

BaldyWeb - Autofill

[apr pillai]

You can use two Dlookup() Functions in separate Text Boxes to display FirstName and LastName values from the ID-Table, when the ID value is entered in the Textbox with the name txtID.

=Dlookup("FirstName","idTable","tblID = " & [txtID])

=Dlookup("LastName","idTable","tblID = " & [txtID])

[funkygoorilla]

@Pbaldy
Hi, thanks for the reply. From my understanding, would the user have to choose from a drop down to get the related info to show? If so, that is not going to work for me, since there would be about 150 options. Is it possible to have the info show after they tab through the field with the ID number?

FunkyG.

[pbaldy]

With a combo, the user can still type in their choice. They don't have to scroll and select. Besides being able to get the other info more efficiently, the combo does the validation for you, making sure the user enters a valid ID (using the Limit to List property). If want to use a textbox, you can use the less efficient DLookup's to get the related info, and of course you need to validate the entry yourself.

[funkygoorilla]

Ok, im getting your idea with the combo box, but the information in the combo box needs to be somewhat secure. Its basically an ID number used to validate a users identity. I really cant have the IDs know to the others, then they would be able to match IDs with the names.
FunkyG

[pbaldy]

Makes sense. You can use the DLookup's as apr suggested. If it were me, I'd probably be opening a recordset on the data to validate the input ID anyway, and I'd get the names from that.

[funkygoorilla]

Hi, thank you both for the help.
I did get it to work with the following syntax.
=DLookUp("[First Name]","tblName","[Seniority ID] = Form![SeniorityIDResult]"
I had to tell Access to look on the current form, hence the Form!, and then the field to look in which is the SeniorityIDResult.


Appreciate the help, this forum is awesome!
FunkyG