Changing data in subform (1 Viewer)

[miked1978]

On my main form I have a combo box and search button. The combo box is just a listing of employees and its data source is a simple employee table. Once a name is selected in the combo box the search button queries a table to get all of the results for that employee and the results are in the subform underneath. That works with no problem. My problem is I want the user to be able to edit all the fields in the subform however I have a field named "Assigned To" and that is the employee name that the user selected in the combobox. I want to be able to change that name but I only want to use the employee names in the combo box/employee table.

I feel like this is easy but i'm having a brain fart.

 

[theDBguy]

Hi. Why not use a combobox for the AssignedTo control as well?

 

[miked1978]

Are you saying use a combobox on the subform where the data is?

 

[theDBguy]

Are you saying use a combobox on the subform where the data is?

Yes. If you're displaying a query, change it to a datasheet form instead.

 

[miked1978]

The subform is a datasheet but where do I set AssignedTo control to look at my employee table?

 

[theDBguy]

The subform is a datasheet but where do I set AssignedTo control to look at my employee table?

In the form's design. Convert the Textbox into a Combobox and set the Row Source to use the same one as your search Combobox.