Microsoft Access Forum

Access Forum

If All Form Data Not Entered Upload Images Link
Tarlok Singh
12 months ago

Hi Richard can you tell me how get prompt and msg box if data in form is not complete in all fields l want get prompt to complete all fields in user form or entry data form and after getting message "data save successfully go to next new record

Kevin Robertson
12 months ago

Use the Form_Unload event (it can be cancelled)

Kevin Yip
12 months ago

I would use a BeforeUpdate event procedure for all the fields. If the user doesn't enter a field properly, he can't even leave the field; he has to stay there until he does.

Richard Rost
12 months ago

You can also use the Required property... but be careful. Remember what I say in Access Beginner 1... NO DATA is better than BAD DATA. If you force a user to enter something, like a phone number, and they don't have it available, they might just enter gibberish. It's easier to go back later and find NULL values than to locate garbage.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments

Subscribe to Access Forum
Get notifications when this page is updated