Tabbing increases record number

[lxh]

Hi there

I have a form (form) and a subform within it (subform) that is sync-ed to it via an tableID. The subform is in datasheet mode as I do not know how many rows will be need. My problem is that when I am in the subform and I'm tabbing through the cells, when I get to the last one on the last row it forces an increment in the tableID in both the form and subform (happens with teh enter key too). I need it to just skip out and continue onto the next cell in the subform, or go back to the start of the subform - or even just stop anythig but incrementing the Record. Can any one suggest a solution?

Many thanks
Lex

 

[o1110010]

Can any one suggest a solution?

See if changing "Cycle" (In the Other tab) to Current Record or Current Page.

 

[lxh]

I works... but only if done in the subform

It works if I set it to "current record" - but only if I set it in the main form - I had tried previously but only in the subform - anyway c'est la vie.

Thanks for the help
Lex

 

[o1110010]

If works if I set it to "current record" - but only if I set it in the main form - I had tried previously but only in the subform - anyway c'est la vie.

Thanks for the help
Lex

You're welcome. Glad you got it resolved.