i have a subform linked to it's parent form (linked via Master/Child fields) so when a surname is selected using a Combobox on the parent form only the matching records are listed in subform.
this works Ok except the whenever time the main form is opened the subform doesn't match the record in the combobox in parent form (ie parent form surname = ALLAN, subform surname = JONES).
the parent form's recordsource is a simple query and the combobox rowsource is also a query and is set to the load the first value (itemdata = 0)
how can i get the subform records to match the parent form when they load?
this works Ok except the whenever time the main form is opened the subform doesn't match the record in the combobox in parent form (ie parent form surname = ALLAN, subform surname = JONES).
the parent form's recordsource is a simple query and the combobox rowsource is also a query and is set to the load the first value (itemdata = 0)
how can i get the subform records to match the parent form when they load?