Form Navigation

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form that adds a new record when you start typing
in the Form Fields. Once the record is saved to the table
it moves to the null record in a table (Code looks
something like this "Private Sub onsendclick() Docmd
Goto.goto last" and the process starts all over.

My problem is that I don't want the user to be able to
navigate back to the previsous record. I took out the
navigation buttons from the form but the mouse wheel will
still allow you to scroll back.

Is there a way to turn this feature off?

-Chris
 
If the user has Insert rights to the table, but not Update, then they would
not be able to change the records. Not sure why you would not want to be
able to go back to a record you just entered. what if you made a mistake
and need to fix it?

Also, even if you take away the scroll wheel, Page Up would also take you to
the previous record.

One solution would be to close the form after each add.

Rick B


I have a form that adds a new record when you start typing
in the Form Fields. Once the record is saved to the table
it moves to the null record in a table (Code looks
something like this "Private Sub onsendclick() Docmd
Goto.goto last" and the process starts all over.

My problem is that I don't want the user to be able to
navigate back to the previsous record. I took out the
navigation buttons from the form but the mouse wheel will
still allow you to scroll back.

Is there a way to turn this feature off?

-Chris
 
Hi,
from the Access Web use example: Disable PgUp/PgDown keys
in a form
http://www.mvps.org/access/forms/frm0016.htm

alternatively have the form recordsource set to an 'empty'
recordset. Then, when moving to the next/new record,
requery the form. This way there are no other records to
navigate to - also avoids record locking in multiuser
environment.

me.recordsource="select table/queryname.* from
table/queryname where ((primarykey)=0);"

Luck
Jonathan
 
Back
Top