Tab Order creates a new record

[ptaylor-west]

I have an input form that has a control on it to create a new record, but what I'm finding is that when I tab through entering data when it gets to the end of the Tab Order it creates a new record, can I stop it doing this ?

 

[Jack Cowley]

In the Forms Property Sheet select the "Other" tab and set the Cycle event to 'Current Record'. Now pressing tab in the last field will sent you back to the first field in that record.

HTH,
Jack

 

[ptaylor-west]

Jack you are a Star......your turning out to be my personal mentor......I have spent all day today on my problems, I don't just jump onto the forum for the answers, otherwise I'll never learn......but it is a great relief when you find the solution......your help really is greatly appreciated