Do not want form to advance

R

Rotata

Hi All,

Access 2003 on XP.

I am rebuilding my database.

How do I make it so that a form does not advance to the next record (or try
to add one) when you hit enter?

Thanks!
 
G

Graham Mandeno

Hi Rotata

In the property sheet for the form (in design view) change the "Cycle"
property from "All Records" to "Current Record".
 
J

John W. Vinson

Hi All,

Access 2003 on XP.

I am rebuilding my database.

How do I make it so that a form does not advance to the next record (or try
to add one) when you hit enter?

Thanks!
Click to expand...

Set the form's Cycle property to Current Record in form design view.
 
Top