Automatically Populate a Field

[Guest]

I want to

*Type in someones surname in the Surname field within a form
*The database to lookup the staff information table
*Locate their Staff ID
*Automatically populate the Staff ID field within the same form

Please help xx

 

[Guest]

Check this link

http://www.mvps.org/access/forms/frm0009.htm

But what if there are two or more with the same surname?

 

[SusanV]

Hi Sarah,

Instead of a textbox control, I would use an unbound dropdown combobox
looking up the surname in the staff info table. (The user can type part of
the name and it will autofill the first match, making it user-friendly and
avoiding typos). Then in the after update event of the combobox, you can set
the autofill of the ID.