Tab Control And Duplicates

[Guest]

Access 2003. I have set up a tab control with a header table and then
subforms. The various tabs have fields from my primary sub-table. If I add a
header record and then click on any tab but the first tab and then try and
input data I get an error message that indicates it can't create the record
because of duplicates on my primary key.

I have tried to put the following code into the exit event of my Title field
in the header record.

Me.sfrmTab1.Requery
Me.sfrmTab2.Requery
Me.sfrmTab6.Requery

It still doesn't work.

However, if I change a field on tab1 in the sub-table, exit the form, and
then return to the form I am able to update the fields on any tab. Any ideas
would be appreciated.

 

[Douglas J. Steele]

See whether Me.sfrmTab1.Form.Requery works any better.