Auto fill ins in a form

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

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