I have a bound form which opens as a new record. If I accidently press carriage return by mistake whilst entering it goes to another new record, how do I stop this behaviour?
I only want the record to save with the click of a button.
I have a form with many fields. It opens on an already existing record selected by the user. The user can change any value in any visible field.
When the user presses enter on one field it moves on to the next one (this is fine and what I want)
But on the last field if the user presses enter it moves on to the next record. It's this i don't want to happen. If it moved back to the top field it would be fine.
I basically want there to be no way to change the record without opening the form on another record.
All the previous ideas are not what I'm looking for. But thanks for trying guys
I have a form that opens on a user specified (or new) record with many fields that the user can edit.
I only want one record to be able to be edited each time the form is opened.
The problem I'm having is if the user is editing the last textbox in the form, and they press enter it moves onto the next record (or a new one if it is the last one in the table).
Ideally I would want enter to move to the next field (which in this case would be the first again) like it does on every other field apart from the last one on the form.
Thank you for trying with all the other ideas, but they are not helping my problem.
Just edited this in:
Oops sorry for the double post, damn IE6 crashed as it was posting that. I just assumed that it hadn't worked. Had to re-type the whole bloody lot.
Oh well it may have made my problem clearer I suppose
Had to re-type the whole bloody lot. 
