Auto fill ins in a form

[Guest]

How can you link two fields (from two different tables) so that when you
enter the id number in a form, it automaticaly fills in the location name,
thereby eliminating entering the wrong id or name. The 'one' table contains
both the id and location name, but the form is based on the 'many' table. I
am using XP

 

[Guest]

If the name textbox is to provide a visual confirmation only, you could try
setting its ControlSource to something along the lines of
=DLookUp("nameCol" , "masterTable", "id = " & txtid)
where txtid is the name of the text field where the user has entered the id.

Hope This Helps
Gerald Stanley MCSD