Tabbing through form creates new record

[jonesda]

Hi,

I have a form with a number of fields and buttons on it. The form is opened in "add new record" mode. I have noticed that when I move from the last field in the tab order to the first field in the tab order it saves an entry in the database.

This is causing me problems because when users move from the last field in the tab order to the field in the tab order an entry is saved to the database but it by passes all the data checks ensuring that certain fields have been filled-in etc.

I don't know why the movement between these two fields is causing an entry to be saved. I don't have code associated with either of these objects. I aslo changed the last field in the tab order to a different field and it still happens.

Any ideas or suggestions would be greatly appreciated.

 

[allan57]

set the form properties cycle = current record

 

[jonesda]

Thanks a million for that allan. That sorted the problem.