Data Entry Property

[brian]

I have my form in data entry mode. When the user opens the reocrd it
doesn't allow any previous records to be viewd but will scroll to the
next record. Also, when a new record is inputted the user can scoll
back to the previous record. Is there a way to filter the reocords
more so the user can only view the current record only?

Thanks

 

[tina]

data entry mode works pretty well - no access to past
records, but allows user to return to previous entries
made in current session to correct errors, for instance.
but if you really want to lock your user into "current
record data entry" only, you can change your form and its'
controls to Unbound. then use an append query or a
Recordset to add the data entry to your table, from a
command button on the form, perhaps.
i've used both append query and DAO.Recordset
successfully, but maybe one of the MVPs can teach us both
a simpler way.

 

[Sandra Daigle]

In your AfterUpdate event of the form just do the following:

Private Sub Form_AfterUpdate()
If Me.DataEntry Then
Me.DataEntry = True
End If
End Sub