Microsoft Access help for a newbie

[Pokey93]

How do you get a field to ?auto complete? itself when a specific value is inputted into another field?

Lets say I have a table with some system information (number ,description, etc.) and I want to link this information to a form. In this form I want to be able to input the system number (i.e. ?1-XX-01?) in one field and in the next field I want the system description (i.e. ?description for 1-XX-01?) to automatically fill itself in.

How would I do this?

Pokey

 

[EagleKeeper]

When the input field loses focus, then run a query on the data in the input field and fill anything else you wish with the data resulting from that query of manipulation.