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
Restrict form to adding only one new record 3
Mouse scroll on Continuous Form looses first record 6
SCROLL THRU RECORDS ENTERED IN FORM 1
Find a specific record 4
Lock to current record 2
Open form to new record 2
disallow moving between records in form 1

Top