Hi I have a problem where I have one table that is split into two forms (one main and one as a pop up). I am also using autonumber ID (as the primary key).
Basically the problem I have is that I can fill out data in the main form which on selecting a response will trigger the pop up form with some check boxes. When a check box is ticked I want the information from the main form and the check box tick to save to the same record on the table, BUT it creates a new autonumber record (i.e. I have a main record with ID of 1 and a new one with only the check box ticked with an ID of 2)
So how can I get both forms to write to just one record?
An easy option is just to have the tick boxes within the main form but the client has specifically requested that a pop up (form) appears.
Any ideas?
Basically the problem I have is that I can fill out data in the main form which on selecting a response will trigger the pop up form with some check boxes. When a check box is ticked I want the information from the main form and the check box tick to save to the same record on the table, BUT it creates a new autonumber record (i.e. I have a main record with ID of 1 and a new one with only the check box ticked with an ID of 2)
So how can I get both forms to write to just one record?
An easy option is just to have the tick boxes within the main form but the client has specifically requested that a pop up (form) appears.
Any ideas?