AutoFill Controls

  • Thread starter Thread starter Tomm
  • Start date Start date
T

Tomm

I have a form that I am creating. The first control is a
drop down box that when I select a record (based on a
query), I want it to autofill textboxes from that record.

Example. The dropdown box has Employee ID based on a
query. When I choose one of the Employee ID's, I want it
to auto fill the First Lame, Last Name, Phone number of
that ID.

How can I do that? Any ideas.
 
Have the combo return the additional fields in columns of zero width. In the
control source of the other fields set it to =Combo.Column(1)
 
Alternatively, have a read up on "About AutoLookup queries that
automatically fill in data"
 
Back
Top