Open form to one specific record only.

  • Thread starter Thread starter patskinny
  • Start date Start date
P

patskinny

I have a form that is launched from a "switchboard" when a user clicks
"add record" cmd button.

The form that is being opened already has many previously entered
records in it.

I can make the form open to a new record, however the user can scroll
back through the previously entered records.

How do i prevent this?

I've tried the setting the cycle property to current record but users
still can look at all records if they scroll backwards with mouse
scroll wheel?
 
Do you want this form to be add-only in all cases, or just when opened from
your switchboard?

If the former, open the form in design view and set its Data Entry property
to Yes. If the latter, change the code that opens the form to
DoCmd.OpenForm "frmName", , , , acFormAdd

If you used the switchboard manager, open the Switchboard Items table,
locate the form and change the command to 2.
 
Back
Top