Getting to a tab on openform

[Swarland]

My db starts by checking if any user ToDo's are overdue - when they are a form gives the user the ability to go to the ToDo parent form.



The ToDo form is a subform on tab 2 of the parent form - but how do I address the subform in a docmd.openform instruction?

Any help always appreciated.

regards

Roger

[RuralGuy]

I take it this is not always the way you want to open this form or the SubForm. How about passing instructions or codes to the next form in the OpenArgs argument of the OpenForm command and executing the instructions in the OnLoad event of the next form?

[Swarland]

When the db is opened up it runs a macro that opens a form (AlertForm) using a query to check for overdue tasks, these are shown in order on the AlertForm, which is a continuous form with record selectors. When the user then selects one of the overdue records shown, it opens the ProjectForm which has a 5-tab control (tabctl14) - the Todo tab is number 2 (named ToDo List) and contains a subform (Project_todoList). This ProjectForm is used within the normal programme and is opened by the ClientMain form if the user requires it.

I am unsure what you mean by "How about passing instructions or codes to the next form in the OpenArgs argument of the OpenForm command and executing the instructions in the OnLoad event of the next form?".

I did start out with the first loaded form opening the AlertForm via the onload event, but the AlertForm was always behind the main form and unseen and I cannot hide a form opened by the user as the .visible option isn't available. Perhaps this is what you are suggesting above, but, I would still have the same problem, opening the correct tab of the ProjectForm.

However, I am happy with the way the Alerts now work, but I would like the ProjectForm to load and open onto the ToDo Tab, rather than just the first tab. This is what I am unable to achieve at the moment, because I don't know how to address the subForm on the tabctl14 tab2 - if indeed it is possible.

Regards

Roger

[RuralGuy]

You can select the 2nd tab by simply putting the focus on a Control that is located on the 2nd tab.

[Swarland]

Once again RuralGuy you have come up trumps, many thanks.

Regards

Roger

[RuralGuy]

Ahh...another satisfied customer!