Command button on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top