M
MSA
I have a main form and which contains some input subforms connected to table
which the user use to input data. Now as the number of records is already
known i.e., Each product can only have 5 enteries based on Area. Since the
also has all the necessary combinations already entered. But it always shows
a an additional new record as default at the very end. The problem manifests
itself when the user use the subform to enter data and tab to this new
default record and since they can't enter anything (Pri. Key inhibition - 1
prod. only 5 record) the application goes into a loop with the pop-up coming
up "Duplication of Pri. Key or Index". The only way to get out is by pressing
the ESC key.
I was wondering is there a way to inhibit this default new record from
showing up on the form since given we know exactly the enteries and are
already defined and stored in the table. Hence no need for the user to enter
a new record.
Thanks for your input.
MSA
which the user use to input data. Now as the number of records is already
known i.e., Each product can only have 5 enteries based on Area. Since the
also has all the necessary combinations already entered. But it always shows
a an additional new record as default at the very end. The problem manifests
itself when the user use the subform to enter data and tab to this new
default record and since they can't enter anything (Pri. Key inhibition - 1
prod. only 5 record) the application goes into a loop with the pop-up coming
up "Duplication of Pri. Key or Index". The only way to get out is by pressing
the ESC key.
I was wondering is there a way to inhibit this default new record from
showing up on the form since given we know exactly the enteries and are
already defined and stored in the table. Hence no need for the user to enter
a new record.
Thanks for your input.
MSA