Submit a new record for each step in an Advanced Form?
I want to create an advanced form so that for each step, whenever it is loaded, I will be able submit a completely new record. The context: - I can use one form with multiple tabs used as steps - or have two forms for the same table, each one used as a step.
How can I accomplish this? How should I set up the Advanced Form?
No matter what setting I do, it won`t work, the 2nd step will always get the records from the 1st step, even though the Record Source setting is left as blank, and the Form Modes are for both steps set to Insert.