9
** Edit **
This post was posted by mistake into another thread (To populate listbox in subform from value selected in parent form), which may contain details relevant to this question.
**
Now I have a problem to synchronise parent and sub forms.
Say in parent form I have a combo box that when a value: a person is selected, a list box on the same form will be populated with the bank names where this person holds account and address of the branch.
I have to use query to populate the list box also cos the bank name and address are held in 2 different tables.
A person can be connected to more than 1 banks and 1 bank can be connected to more than 1 persons.
When a row in list box is selected, the sub form initially should display the details of the account held in that branch that has a flag "main" selected. But when left/right arrow button is pushed, the sub form can display the details of other accounts held in the same branch.
On the recordsource of the parent form, I put the name of the table that connects person ID to account ID.
And on the recordsource of the subform, I put the name of the table that has details of each account ID.
A person can have more than 1 accounts, but only 1 account that is marked as "main".
So the main and child field is the account ID on both tables.
My question is how to synchronise the display of the parent and sub form. Somebody suggested using recordsetclone and bookmark, but I'm not familiar with this concept, so any tips are much appreciated.
