DLookup AutoFill Help

[Guest]

Hello, I have a Form that I would like the auto fill option but cant figure
it out. I have been reading that the dlookup is the way to go but I dont know
how to do it and was woundering if some help could be provided? I have a form
named frm_AccidentIllnessEntry and On that form I have a few text boxes I
wanted auto filled. I would select the employees name from a combo box and it
would auto fill my other txt boxes. The Control source of my text boxes are
Date of Hire:, Department:, Sex:, DOB:, Weight:, Height:, I have this
information already in a Table called tbl_EmployeeInformation. I guss im
asking how do I pull the information from tbl_EmployeeInformation into each
one of these text boxes when a name is chosen from the combo box? Thanks!!!

 

[Guest]

Hi oxicottin,

One way is to have the additional data you want returned with the combo box
in columns with their width set to zero, this will have the info available to
you but not displayed in the combo box.

Then, have a text box that has the data source set to
=me.COMBOBOXNAME.column(2) or whichever is appropriate.

Hope this helps.

Damian.