Requery a subform form a combo box in a main form!

[lewisoh]

Good morning,


I have a problem trying to requery a subform from a combo box used to select a category in a main form. I have tried several variations in the coding but nothing seems to work. I know the suform works because when I open it up separately, it asks for the data selected from (combo0) I type in a category and it filters correctly. It appears to be something in the way I am structuring the (Combo0) AfterUpdate property’s coding. This is what I have;
Main Form: Category View Form
Subform: Category View Subform
Combo Box: ComboO
AfterUpdate: Private Sub Combo0_AfterUpdate()
Forms![Category View Form]![Category Query subform].Requery
End Sub
I have tried the above coding which does nothing. I have tried Forms!Category Query subform.Requery
Which produces “Compile Error:
Syntax Error”
message. So my question is what am I doing wrong? Thanks for the feedback!

[JamesDeckert]

here's a great reference
http://access.mvps.org/access/forms/frm0031.htm

try this
Me![Category Query subform].form.Requery

[lewisoh]

[QUOTE=JamesDeckert;292163]here's a great reference
http://access.mvps.org/access/forms/frm0031.htm

try this
Me![Category Query subform].form.Requery

Itried the above mentioned and the subform did nothing similar to the first code I had tried. I am thinking that the AfterUpdate is not seeing the subform it is trying to reference for whatever reason. I am really new to Access so this is pretty deep for me. I had succesfully made a second combo box filter by what was being put into the first one in another form, but I think that was working because both combo boxes were in the same main form. Tere appears to be something you must do differently when referencing a subfom. Even though it is on the same main form it is a form itself. At least that is what in my very novice opinion I was thinking.