Prevent blank records on form.

[Guest]

What is the best way to prevent a blank record. In other words my users will
click the next record at end of form records (on the record selector arrows
on bottom of form). This will mistakenly create multiple blank records. How
can this be prevented. Perhaps I can modify one field within this form to
not accept a blank field. Or, force an entry in one field. How can I do
this? Unless you have another suggestion. Thanks.

 

[Guest]

The form has an OnUpdate property. In that, you can check that a field has
been entered. Or, you can diable AllowAdditions. Require that they click a
button to add(Enable AllowAdditions), then the same button to save. When
clicked to save, validate the entry.

 

[tina]

it shouldn't, unless the user is entering some data - or you have code
somewhere that is automatically entering a value in a field on NewRecord -
thus creating a record. if the former is the case, you can make one or more
data entry fields required, so the user must enter data or Esc to undo the
record entirely. if the latter is the case, you might try moving the code to
the form's BeforeInsert event procedure, so the value is not written to a
field until the user begins entering data in the record.

hth