Changing data in subform (1 Viewer)

miked1978

New member
Local time
Yesterday, 23:42
Joined
May 22, 2020
Messages
25
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

I’m here to help
Staff member
Local time
Yesterday, 21:42
Joined
Oct 29, 2018
Messages
18,972
Hi. Why not use a combobox for the AssignedTo control as well?
 

miked1978

New member
Local time
Yesterday, 23:42
Joined
May 22, 2020
Messages
25
Are you saying use a combobox on the subform where the data is?
 

miked1978

New member
Local time
Yesterday, 23:42
Joined
May 22, 2020
Messages
25
The subform is a datasheet but where do I set AssignedTo control to look at my employee table?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:42
Joined
Oct 29, 2018
Messages
18,972
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.
 

Users who are viewing this thread

Top Bottom