multiple record copies on Subforms

[mackyrm]

I have a problem with combo boxes set up on subforms

I have 4 tables.

Table 1 (tblContacts) & 3(tblSession) are linked by an index table, table 2 (tblContactSession). Table 4 (tblCourse - can have many sessions) is a parent/lookup table to table 3.

I have a form with table 1 as the main source. Table 2 and 3 make up the multiple records in the subform. These records have 2 combo boxes. A user uses combobox 1 in the subform and selects an item from table 4, this item determines what a user can select from combobox two (records they can see in table 3), selecting an item in combobox 2 inserts the item code/ID into the index table, providing part of the primary key for this new instance of a record.

PROBLEM:
Selecting an item on one combobox, selects the same session for all records in the subform relating to that client. Anyone help?

Thanks!

 

[Dennisk]

this is because your combo box is unbound and effectively you only have the one combo box and its contents displayed for all the records.

Access has always been like this. One way around this is to display the subform data in a list box and add a button to the form that opens a new form so you can add a new sub record.

 

[mackyrm]

Is there no other way? Perhaps some kind of current record method that allows VBA to work with the current selected record in datasheet view?