I want to be able to update a record.
I have a form with a combobox (cbxTrainee) and a subform. I want the subform to show all the records that belong to the name that is selected in the combobox (cbxTrainee) when I click the button (btnFind).
How do I set the recordsource of the subform to the sql string created when clicking the button.
The subform data also needs to be editable