Main form clears when attempting to access linked subforms

[carlcwc]

I have a main form; Client File, the linked subforms are on individual tabs in the main form. All forms are linked by the PK "ClientID".
What's happening is that when I finish filling out the last field of the main form and hit the tab key on my key board, the all of the fields clear out. The informatoin gets saved but when I attempt to fill in the other subforms I can not use the Client ID because I get an error message telling me that the number already exists and duplicates are not allowed.
If I don't hit the tab on my keyboard and instead scroll back up and access the subform then all of the information stays in place and the whole thing works fine.
What I want to have happen is when that last field is filled in and the tabkey or enter key is hit then the information stays in place and the user is automatically taken to the next subform.
Your help is most welcomed.

 

[Beeps]

hi carlcwc,

Have you tried setting the tab order for the forms? In design view, right click and select "tab order". Set your order so that the subform "control" is last. Then do the same for your subform. Once your tab order goes to the subform, your tab order will go the subform order without adding a new record to your main form.

Hope it helps

 

[Darrylles]

Hi carl,

Beeps is right.

When you leave the last field in your current record - Access displays the next blank record.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk