Record lock issue (I think)

  • Thread starter Thread starter Philip
  • Start date Start date
P

Philip

Hello all

Have only recently come back to programming in Access.
Now Using Access 2003
I seem to have forgotten how to lock a bound form so that hitting tab or
enter on the last field simply returns focus to the first field on the same
record, not advance to the next record. How do you stop the form from
advancing to the next record without limiting the recordset via Rousource or
Filter?

I seem to remember it was a Form Property, something like the RecordLocks
but that dont seem to work. where do you do this?

Thank in advance.
Philip Middleton.
 
In the properties window of the form, set the "Cycle"
property to "current record". (Located on the Other tab).

Rgds,
Glenn.
 
Back
Top