Prevent blank records from being saved

[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

 

[Dirk Goldgar]

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.

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.