Basing one combo box on another in a subform

[LFosterAccess]

I have created a combo box that limits its list based on the selection made in another combo box. I also entered an event procedure (AfterUpdate) to keep the combo box updated. It works fine when it is in its own form; however, when I put these combo boxes in a subform, I am prompted for a parameter value when opening the main form. This is most likely because of the order of event procedures but I do not know how to fix it.

[RuralGuy]

The syntax to reference a control on a form is different when it is a SubForm.
http://www.mvps.org/access/forms/frm0031.htm

[bkelly]

I was just browsing and found this thread.
This goes in the favorites.
Great link RuralGuy.

[RuralGuy]

I was just browsing and found this thread.
This goes in the favorites.
Great link RuralGuy.

That site is probably either the best or at least way at the top of the list of great Access sites.

[brock]

I have created a combo box that limits its list based on the selection made in another combo box. I also entered an event procedure (AfterUpdate) to keep the combo box updated. It works fine when it is in its own form; however, when I put these combo boxes in a subform, I am prompted for a parameter value when opening the main form. This is most likely because of the order of event procedures but I do not know how to fix it.

Hi i Have same problem but i cant figure the info in the link provided by RuralGuy. Can you help me with sintax for my case.



I have form TESTINFO as a subform of TESTEVENT.
I am using 2 combo boxes in TESTINFO (First combo is filtering second ).
Its working on TESTINFO form but when is it a SUBFORM to TESTEVENT i get popup to populate the parametar. ( I used microsoft guide to get to this point)

//Query name cboQuestion - criteria for TestID
IIF(IsNull([Forms]![TESTINFO]![cboTestCode]), [TestID],[Forms]![TESTINFO]![cboTestCode])

AlSO

//ON CURRENT - I got this on FORM TESTINFO
Private Sub Form_Current()
Me!cboQuestion.Requery
End Sub


//AFTER UPDATE COMBO - I SET THIS UP ON first combo box
Private Sub cboTestCode_AfterUpdate()
Me!cboQuestion.Requery
Me!cboQuestion.SetFocus

[RuralGuy]

A form used as a SubForm is no longer in the Forms collection. In order to reference the SubForm you need to go through the MainForm.
Where as a MainForm the reference is:
Forms.MainForm.ControlName
...as a SubForm the reference would be:
Forms.MainForm.SubFormControl.FORM.ControlName

[brock]

A form used as a SubForm is no longer in the Forms collection. In order to reference the SubForm you need to go through the MainForm.
Where as a MainForm the reference is:
Forms.MainForm.ControlName
...as a SubForm the reference would be:
Forms.MainForm.SubFormControl.FORM.ControlName

Sorry if this is annoying to you, but i dont understand

1.Do i need to change the query or events code ...or both
2. My sintax has all this ! [] and yours is just ". . . "

If you can give me an example that would help me visualize ( i dont know what should i put for SubformControl.FORM)
???????????? .???
Thanks

[brock]

HOLD ON Before you snap at me ...I think i GOT IT ( query)

IIf(IsNull([Forms].[TESTEVENT].[TESTINFO].[FORM].[cboTestCode]),[TestID],[Forms].[TESTEVENT].[TESTINFO].[FORM].[cboTestCode])));

Confusing part was SubformControl which = "SUBFORM" ///"TESTINFO" in my case

[RuralGuy]

Excellent! FYI, forms are displayed on other form by the use of a SubFormControl and this SubFormControl has a name of its own that defaults to the name of the form it is displaying but need not remain so. It is the name of the SubFormControl that is used in the syntax to reference controls on a SubForm.