Prevent blank records from being saved

  • Thread starter Thread starter Nick C
  • Start date Start date
N

Nick C

Does anyone know of a proven solution to this problem? I currently have a
message box prompting users not to save blank records, but it is still
creating problems. Any help would be greatly appreciated.

Thanks in advance,

Nick
 
Nick C said:
Does anyone know of a proven solution to this problem? I currently
have a message box prompting users not to save blank records, but it
is still creating problems. Any help would be greatly appreciated.
Click to expand...

If you go into design view on the table the form is based on, and set
the Required property to Yes for all the fields you don't want to be
left blank, then it will be impossible for a user to save a record
without entering data in those fields.
 
Back
Top