Hi Karen,
Saw your posts, I face some situation.
1. I Had A form with More Than 10 subforms, I put this into 2 tab (Avg 1 tab
holds 5~8 Subform).
2. Which subforms to displays depends on Main Form ComboBox> Generate Form2>
Subform Display Base on Choice.
3. This is preset in the form>
* * * * * * * * * *
TabControl1.Visible = True
Page1.Visible = True
Subform/ SubReport1.Source Object =Subform1
Subform.Recordsource = Query1
* * * * * * * * * *
4. Programmatically in VBA Form_OnLoad():
if(MainForm_ComboBox.value = "Subform1Name")then
Tab1.visible =true
Subform1.visible =true
elseif (MainForm_ComboBox.value = "Subform2Name")then
.
.
.
EndIf
5. Results: When Form is Load> No Tab/Subform is shown ! *duh
Note: I Run the Subform individually, everything seems ok (Display desired
output accordingly)
6. What possibly could goes wrong ?
Edison
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
|
|