M
multi forms to one table
i'm facing problem in fixing an appropriate Command Button to move from one
form to another
The database is designed with multiple forms (3 forms) linked to a master
table. In order to perform a full cycle of one line of record in this master
table, the user needs to input all 3 separate forms in a series of order.
Practically, every new cycle of input, only my First Form allows a fresh new
record input while other forms overwrite my old line of record.
Therefore i need to have a Command button that adds new record whenever i
move on from one form to another
form to another
The database is designed with multiple forms (3 forms) linked to a master
table. In order to perform a full cycle of one line of record in this master
table, the user needs to input all 3 separate forms in a series of order.
Practically, every new cycle of input, only my First Form allows a fresh new
record input while other forms overwrite my old line of record.
Therefore i need to have a Command button that adds new record whenever i
move on from one form to another