Subforms in Tab Pages. Handling Startup actions for subforms

[Sarvananda]

I have two forms:
1. Donor
2. Patron

I want to bring the two forms together in a tab control on separate pages.

I had some startup actions to be triggered for each form. Which event in the tab control page should I use for these?

The onLoad event was what I was using when these forms were independent. Now as subforms on the tab control, the OnLoad event is triggered when the main form is loaded. This creates a problem and new records in either form do not get saved. Which events should I use for triggering actions when these subforms get the focus?

Thank you in advance,
Sarvananda

[ChipR]

The subforms have a Got Focus event. You may have to explain what you are trying to do a little more. Is the problem with startup actions (don't know what that means), or saving records, or something else?

[NeoPa]

When you say SubForm, do you mean the control (which is a SubForm) or the form it contains (which isn't)?

Like Chip, I'm a bit confused as to what you actually want.

[Delerna]

I think Sarvananda means where to put the code that used to be in the onload event of each subform now that they are in the tab pages of a tab control

Private Sub NameOfTabControl_Change()
   MsgBox NameOfTabControl.Value
End Sub
 

Sarvananda

The above code will execute each time you change tabs on the tab control and
NameOfTabControl.Value will tell you which tab is active. 0 for the first tab, 1 for the second, 2 for the third etc etc.

Use that to decide which modified version of your "OnLoad" code from your original forms to run


Does that help?

[Sarvananda]

Thanks to ChipR, NeoPa, Delerna for your kind responses

We are back from a big restructuring of office network. We are not yet through but the Broadband is somewhat restored.

The two subfroms are actually data entry subforms.
When a tab is opened for the first time, the following should happen in the subform of the tab
1. Create New Record in the subform
2. Generated Unique ID
3. Lock Unique ID Control (Text Box)
4. Set focus on next control in data entry sequence

These should not recur on subsequent access to the tabs.
Data should be validated before being saved in either subform
Tab controls enable rechecking previously entered data before finally saving the records.

I needed advice on how to implement these.

Thanks in advance
Sarvananda

[NeoPa]

I expect this is a simple language issue, but before you ask for further assistance it would be nice if you replied directly to the questions posed to help clarify what you've already requested.

If, when asked clarification questions, you decide instead to start to explain again from scratch, then we may be here a long time.

[Sarvananda]

Thanks for your advice NeoPa. I will try to follow it.