Submit Button with multiple field checks and message box

[wrweaver]

I'm creating a work order submission form where I want the person submitting to have to fill out 6 fields before they can submit the saved record. I need a button that will check each of those fields and if one is isn't filled in, display a message box saying which field is missing. Then, if all the fields are filled in, the button will save the record, close the form, and tell them they have submitted the work order. And if they decide not to fill out the form they can exit it without it saving.

I have no idea where to start.

Any help would be greatly appreciated! Thank you!

 

[jdraw]

I suggest you start with a data model.
see http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

You seem to be into the "forms and controls" area, but you have said nothing about your tables or relationships, nor any business facts.

 

[wrweaver]

There are six fields on the form all stored in one table. What else do you need to know? Each of the six fields is on the form. Theres a picture of the form.