Command button on form 1

[cldh00]

I have a form in which I created a command button. When I click on this command button, I want it to open a query, which I have done. This query has an employeeID field and a name field. When I select the row in which I want, I would like the EmployeeID information from the query to be sent over to the form in a textbox called "EmployeeID". I'm not sure on how to get started on this. I could also set up the query to have a third column full of checkboxes, so when I click the checkbox, that rows EmployeeID info will be sent to the textbox in the form. Any ideas?

Chad

 

[cldh00]

I would like to alter my question. Instead, I now have set up a combo box that reads a query's employee ID field and the name associated with it. After I click the combo box and set up the correct employee ID, only the employee ID shows for the combo box, which is what I want. However, after I select a number from the combo box, I would like for this number to automatically be sent to a text box named "EmployeeID". How would this be done?

Chad

 

[spizotfl]

could put something like :
me.EmployeeID = me.CombosName in the after update for the combo