Do not want form to advance

[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!

 

[Graham Mandeno]

Hi Rotata

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

 

[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!

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