required property /validation rule

[eb1mom]

I have a form with 5 fields the required property of each
field is set to yes in the table. I have two command
buttons, one for new record and one to return to main form.
When new record is clicked and all five fields are not
filled, an error message is generated. However,when the
return to main form button is clicked no error message is
created and user can return to main form without completing
record. User can also close record without completing.
After searching for answers here, I think I need to create
a validation rule for the form. I am new to validation
rules so any help on how to correctly create them would be
appreciated.

 

[Allen Browne]

Explicitly save the record before you return:
RunCommand acCmdSaveRecord

That will generate an error message if the record cannot be saved.

 

[Guest]

Thank-you! Your website is great.The traps section has me
fixing many flaws.