Can someone help me please?
I have a main form (subscriptions) and a subform (subscriptions subform). Upon opening the main form, the subform datasheet automatically goes to a new record allowing new data to be entered. Underneath the subform I have a number of combo boxes which transfer data into the same table that the subform is linked to (subs table).
My problem is when I enter a new record in the subform and then select the options from my combo boxes, it transfers the combo data into the first record in the Subs table, not the new record as I would like it to do. The combo box data comes from a separate table (market).
The combo boxes are obviously linking to the subform as it puts the data into the table, it just seems to be defaulting to inputting into the first record.
I am assuming I need some sort of on event or requery, Any suggestions?
I have a main form (subscriptions) and a subform (subscriptions subform). Upon opening the main form, the subform datasheet automatically goes to a new record allowing new data to be entered. Underneath the subform I have a number of combo boxes which transfer data into the same table that the subform is linked to (subs table).
My problem is when I enter a new record in the subform and then select the options from my combo boxes, it transfers the combo data into the first record in the Subs table, not the new record as I would like it to do. The combo box data comes from a separate table (market).
The combo boxes are obviously linking to the subform as it puts the data into the table, it just seems to be defaulting to inputting into the first record.
I am assuming I need some sort of on event or requery, Any suggestions?
