I have a table that has several field that all have to be populated.
On the data entry form is a button to append the data to the main table.
If someone presses the "Append" button prior to all of the data being populated then all hell breaks loose and the stop macro form appears.
I woiuld like advice on how best to manage this error.
I am happy with the pop ups saying that certain fields need to be populated but when it comes the choice of "Do you want to close the database object anyway?" If I select "No" I want to stop the Macro and return to the form to complete the rest of the data.
hope this makes sense.
I'll try to do some reading myself to see if i can figure it out.
Cheers people
On the data entry form is a button to append the data to the main table.
If someone presses the "Append" button prior to all of the data being populated then all hell breaks loose and the stop macro form appears.
I woiuld like advice on how best to manage this error.
I am happy with the pop ups saying that certain fields need to be populated but when it comes the choice of "Do you want to close the database object anyway?" If I select "No" I want to stop the Macro and return to the form to complete the rest of the data.
hope this makes sense.
I'll try to do some reading myself to see if i can figure it out.
Cheers people