Diplaying info in a TextBox from a Query using a ComboBox

[sksbizkit]

So i have a Combo Box that displays all employees from "Query1" on "Form1" and within that "Query1" is fields "Birthdate","Emp_id","Emp_Name". I also have a textbox on that "Form1". I have the combo box displaying all the employees fine, but what i want to do is when you select a employee from the combo box it displays there corresponding birthdate in the textbox..???? Please Help

Thanks

 

[PHV]

Have a look at the Column property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886