enter parameter value

[joeblow2]

Hi:
My setup is as follows:

I have a Main form which has a listbox (List33) from which I (on selection of an item) want to populate another listbox (List11) on a sub-form of a sub-form of the main form.
My code on the main form is:

Private Sub List33_AfterUpdate()
Dim stDocName As String
stDocName = "Query2"
Me![sub Participant_line].Form![sub Response].Form!List11.RowSource = stDocName

End Sub

and my query(Query2) has a "which" part of the sql as:

[Me].[Parent].[Parent]![List33]![Column(0)]

However, When I click the item in Listbox, List33, I keep getting the "Enter Parameter Value" Message box popping up.How please can I fix the problem.
Thanks in advance.

 

[khawar]

[Me].[Parent].[Parent]![List33]![Column(0)]
Why are you using parent twice

 

[rainman89]

take a look here. I believe your syntax is a little messed

 

[joeblow2]

Thanks for your help.