I have 2 tables (tblName and TblOffense) and a form with a subform (frmOffense and frmSubEdit) In the table (tblOffense) there are several entries for an offense and each offense will have an entry for each person involved.
i.e.:
Offense IDNumber charge decision
0001 p12345 244b denied
0001 q23456 244b accepted
0001 d13579 123c pending
0002 r12457 233f rejected
In the main form you select the offense number from a combo box (the combo box is populated from a DISTINCT query) The ON Change event then populates a second combo box with the ID numbers of the persons involved. I want the sub form to display and edit the data that pertains to the record selected. (Offense and ID number match) I have the subform bound to the Offense table. I can't figure out how to make the subform populate with the data. I am pretty sure I have to reference the subform and a bookmark and that by doing so, the changes made in the subform will change the table directly...So how do I get the subform to populate?
i.e.:
Offense IDNumber charge decision
0001 p12345 244b denied
0001 q23456 244b accepted
0001 d13579 123c pending
0002 r12457 233f rejected
In the main form you select the offense number from a combo box (the combo box is populated from a DISTINCT query) The ON Change event then populates a second combo box with the ID numbers of the persons involved. I want the sub form to display and edit the data that pertains to the record selected. (Offense and ID number match) I have the subform bound to the Offense table. I can't figure out how to make the subform populate with the data. I am pretty sure I have to reference the subform and a bookmark and that by doing so, the changes made in the subform will change the table directly...So how do I get the subform to populate?