basic question on form operation

[Guest]

I have a data entry form with 6 fields. I don't want any of the data to
update to the table unless all fields are filled in and the user clicks the
"Submit Request" button. If one of the fields are blank, I need an error
message to display saying not all fields are complete or to click the cancel
button. If the cancel button is clicked, none of the data is entered into
the table. How could I accomplish this? Thanks

 

[Allen Browne]

The simplest solution would be to open your table in design view, and set
the Required property to Yes for all 6 fields. Then Access won't save the
record unless all fields have a value.

You then don't need to worry about forcing the user into the straight-jacket
of a Submit button.