How to make the save button work like I want it to

[Candace]

Another queston,



When I click the save button that saves the record, it does except errors popup because there are fields that can't be null. The message pops up to say it needs filled in and thats fine. But I want the same button to also close after all the fields are filled in as they should be. If I have it save and close it says it can't right now and do I want to close anyway and if I say no it goes back to the form. If I say yes another error about a Macro error pops up. It's ugly and I would rather that not happen. How can I make the save button que me to fill in the fields and then when they are all correct save and close the form?

[orange]

Access will save record when you move from that record, provided any/all validation is completed.

If you allow a field to be Null (Required = False), then if you move to another record, the first record will be saved.
Maybe there is more to your question. We haven't seen many details nor a description of your project/database.

[Candace]

Thank you....I looked here at some other posts and found how to build what I needed to have happen on the save button. It works perfectly! This is a wealth of informaton once you figure out what you need to look for.