Record lock issue (I think)

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.
 
G

Glenn

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

Rgds,
Glenn.
 

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

Top