Unanswered: Adding dependent combos to an existing form...
I have got one combo box that shows the client name, when a name is chosen the second combo updates to show only that clients meds.. It works great.
Info is pulled from tbl_Clients and tbl_Medications respectively.
How can I add these results to another table called tbl_Medincidents?
If I use tbl_MedIncidents as the Forms record source my combos dont affect any fields.
Im wondering how to tie the existing tblMedIncidents with my 2 combo boxes?
Well, since the control source isn't a field in the table, the value won't be saved anywhere. Does it have to be, or can it be derived from the combo? If it has to be, then you'd have code in the after update event of the combo to set the value of a bound textbox to the same value you currently use for display: