Hi all,
I have a database which is being used for storing name, order #, part number and serial to that part number.
Name and Order Number is setup on the main form, part number and Serial Number is setup on the sub form. I have many users that use this database and I have recently noticed a problem which I need your help with:
If a user chooses his/her name and enters order number and then accidentally closes the database, then the database stores it like that, with just name and order number. The problem with that is that I want each user to enter the rest of the info as well. For example, if they enter name and order number then they have to enter at least one part number and one serial before they can exit.
To fix the problem I went ahead and made part number and serial in the sub form required but that didn’t help at all.
Any suggestions
Thanks
I have a database which is being used for storing name, order #, part number and serial to that part number.
Name and Order Number is setup on the main form, part number and Serial Number is setup on the sub form. I have many users that use this database and I have recently noticed a problem which I need your help with:
If a user chooses his/her name and enters order number and then accidentally closes the database, then the database stores it like that, with just name and order number. The problem with that is that I want each user to enter the rest of the info as well. For example, if they enter name and order number then they have to enter at least one part number and one serial before they can exit.
To fix the problem I went ahead and made part number and serial in the sub form required but that didn’t help at all.
Any suggestions
Thanks