I was just wondering if it is possible that when you have a main form with 2 subforms(continuous) to be able to make a single command button that clears both subforms and allows you to keep the previous main form values so that a single field change in the main form creates a new record.
For example main form has:
Field1(autonumber)
Field2
Field3
Field4
Field5
Now I click a button the 2 subforms are cleared and the mainform advances to the next record so I can change just Field5. The autonumber will have advanced but Field2, Field3, and Field4 are the same as in the first record.
Hope I am explaining this well enuf to get some help.
For example main form has:
Field1(autonumber)
Field2
Field3
Field4
Field5
Now I click a button the 2 subforms are cleared and the mainform advances to the next record so I can change just Field5. The autonumber will have advanced but Field2, Field3, and Field4 are the same as in the first record.
Hope I am explaining this well enuf to get some help.