D
Dave M
I have a switchboard setup to open a form in add mode. This is working fine.
The problem is that I have some code that when selected will add fields to
another table based on this new record I am currently creating. The code
works fine for an existing record but not for the new record as the empID
(autonumber) has not been saved and the record is not in the table yet.
If I do save the record it goes to a new record as it is in add mode.
Is there a way to save the record and keep it on the same record so that I
can then run the code?
The problem is that I have some code that when selected will add fields to
another table based on this new record I am currently creating. The code
works fine for an existing record but not for the new record as the empID
(autonumber) has not been saved and the record is not in the table yet.
If I do save the record it goes to a new record as it is in add mode.
Is there a way to save the record and keep it on the same record so that I
can then run the code?