Prevent User Errors with form. - Looking for advice

[djspod]

Hi All,



I have built a form which is now working very well and nearly finished in my DB.

Before letting it loose with the users I want to 'Idiot proo'f' it from breaking on the user.

If the User starts to initiate a new Record but only goes part way in and then decides to click a button for another section of the database (Fills a couple of records in, generates the auto Ref ID)

Access then complains that the record is not finished , there is no record matching a field and another field etc. etc.

I know what that is complaining about but the user won't know or understand, I want to stop this from happening and prompt the user to do the right thing to either complete the started record or End/reset it (Like pressing the escape key)

Can anyone share any advice on the right direction to tackle this?

Thanks

Darren



Attachment 28276

Attachment 28277

[RuralGuy]

You do know that every form has an error event that can intercept those type of errors, right? You can then put up your own explanation of the issue and keep the system error from showing.

[djspod]

Hi RuralGuy,

That's kind of what I was asking and how?

I'm still fairly new to VBA and error handling

Thanks

Darren

[RuralGuy]

Post back if it is still not cooperating but see if this link helps at all: http://allenbrowne.com/ser-23a.html