Subform unable to present Query Output ?

  • Thread starter edisonl via AccessMonster.com
  • Start date
E

edisonl via AccessMonster.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trapping SubForm Events/names 14
Form Reference to Labels 2
Trouble with Focus-Subform to MainForm 2
How to cancel a form's close properly after subform's BeforeUpdate cancels 0

Top