AutoFill Controls

[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.

 

[JohnFol]

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)

 

[JohnFol]

Alternatively, have a read up on "About AutoLookup queries that
automatically fill in data"