Don't Advance to Next Record

[jocat]

I am working on a database to track invoices. I have created a form for data entry of new invoices and editing of existing invoices. I have placed a "Save Record" button in the form footer. I want to require that the entry clerk use the "Save Record" button.

The problem is that when the enter key is hit while in the last field of the form, the record is saved and it advances to the next record. How do I prevent this and restrict saving the record to the "Save Record" button.

I did it before, but I can't remember how. I would like a beep, or message box to appear (or both) when the enter key is hit while in the last field of the record.

I am using Access97.

Any help would be greatly appreciated.

Thanks in advance.

Jocat

 

[PHV]

Take a look at the Cycle property of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jocat]

It worked.

Thanks much. I will record this in my reference file so I don't forget again (I'm getting old).

Jocat