stop Records

[kevcar40]

Hi
i have a form that accepts data from users

Is it possible to stop a user from entering data for a new record
until the previous record is complete?


thanks

kevin

 

[BruceM]

If by "complete" you mean that certain fields must contain values, you can
set those fields to Required in table design view (table-level validation).
You could also use form-level validation, either with or instead of
table-level validation. The form's Before Update event is a good place for
such validation. For instance:

If IsNull(Me.ZipCode) Then
MsgBox "You must include a zip code"
Me.txtZipCode.SetFocus
End If

There are many variations, depending on your specific situation.