Text box reading table data

[Melbourne]

Hi,

I have a text box on my form that reads the staff ID number. Is it possible
for the text box to reference and display the staff name?

Thank you

Paul

 

[Allen Browne]

I have a text box on my form that reads the staff ID number. Is it
possible
for the text box to reference and display the staff name?

Use DLookup() to get the name from the table.

For help with DLookup() see:
http://allenbrowne.com/casu-07.html

Alternatively, you could use a combo box.