Prompt user warning of null entries

[supanoods]

I'm not the best VB coder in the world - always no enough to get me by, but have now hit a stumbling block...

I have a standard data entry form and at the bottom a SUBMIT button (basically creates a new record and clears the form). At the moment there is no confirmation of the new record being submitted, therefore...

Can anyone give me some pointers on creating a suitable confirmation message, and if possible - show me how I could go about listing any blank or "null" fields on a message box prompt. Which if includes blank fields - tells the user what to complete before creating record.

Thanks in advance!

Supanoods B-)

"If it aint broke - dont fix it!

 

[PHV]

The usual way is to enforce the rules in the BeforeUpdate event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[supanoods]

Thanks 4 the quick response!

When you say "enforce the rules", I am a little confused. Do you mean that I should declare which fields that are mandatory? Because I do have certain fields (like Date) that MUST hold a value - therefore I have made the field mandatory in the table that holds the records that this form produces. Doing so means that if I leave a mandatory field blank, an access error message appears - but to the average user, this prompt will confuse.

"If it aint broke - dont fix it!