stop tab at the last filed ?

[siamandm]

Hi,
i have two tables with one-t0-many relationships, and i create two forms one is main and the other is subform linked to the main form ...
inside the subform i have some files, during data entry, when I move with a tab between the fields .. at the last field when I press tab on the keyboard it will add new row set to the current ID which I don't want this happen
i hope i cleared out my point..

your help is much appreciated.

regards

[HansV]

Open the subform in design view.
Set the Cycle property (in the Other tab of the Property Sheet) to Current Record.

[siamandm]

you are star Hans

thanks alot