Default Start Tab on a Form

bradford

Hi, I have modified the Campains Form to include more tabs on the form.
The tabs have subforms linked to them where the Campain Number = the Campain Number in new tables I created.
The problem is that when I open the Campain form and the subform does not have any related data, the form opens on the Tab with the subform and not the Main (first) tab.
If the subform table has related data, it opens on the first tab.
I have tried setting the "CurrForm."No.".Activate" at various stages without success.
There is a Table link set up between the Campain form and the subforms.
Any suggestions? :shock:

Waldo

Did you try to set the DelayedInsert-property on the subform?

bradford

Fantastic, works like a charm thanks...

Waldo

No prob 8)
Can you put [solved] in the subject, please?