Open form to one specific record only.

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?
 
J

Joan Wild

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open form at specific record from switchboard 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Crating User Form to Add Names 1
Lock to current record 2
Mouse scroll on Continuous Form looses first record 5
SCROLL THRU RECORDS ENTERED IN FORM 1
filtering a form based on the values of a subform 0
DMax on existing record to increment serialized # fails 1

Top