Automatically Populate a Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top