M
Mike
I'm getting the following error when I try to set the recordsource property
to a query in my database:
"The expression you entered refers to an object that is closed or doesn't
exist."
Below is what I have in my AfterUpdate method for my selectbox:
Private Sub Combo36_AfterUpdate()
Me.Child16.Form.RecordSource = "General_query"
End Sub
Combo36 is my selectbox (combobox)
Child16 is my subForm
General_query is the name of my stored query in the db
So when ever I select an option in the combobox on the main form I get the
above error. Could anyone help?
The idea is that I will have selections listed in the combobox and when a
selection is made I will have a If condition in the Afterupdate method to
assign a specific Stored Query to the recordsource property of the subform.
Which then the subform should use that query to run it and display its
contents.
TIA!!!
to a query in my database:
"The expression you entered refers to an object that is closed or doesn't
exist."
Below is what I have in my AfterUpdate method for my selectbox:
Private Sub Combo36_AfterUpdate()
Me.Child16.Form.RecordSource = "General_query"
End Sub
Combo36 is my selectbox (combobox)
Child16 is my subForm
General_query is the name of my stored query in the db
So when ever I select an option in the combobox on the main form I get the
above error. Could anyone help?
The idea is that I will have selections listed in the combobox and when a
selection is made I will have a If condition in the Afterupdate method to
assign a specific Stored Query to the recordsource property of the subform.
Which then the subform should use that query to run it and display its
contents.
TIA!!!