Stop TAB creating New Record

[wrightyrx7]

Hi all,

I have 2 forms, both pretty similar.

But I use one for creating new records in a table.

And one to View/Edit exiting records.

When I open an existing records, and tab through the fields. Once I pass the last field it creates a new record.

How do I stop this.

Thanks in advance
Chris

 

[MarkK]

A form has a Cycle property. Find it on the 'Other' tab of the form's property sheet in design view. Set it to 'Current Record.'

 

[wrightyrx7]

As simple as that haha... worked as I wanted.

Thank you so much