Hi Guys,
was just wondering if anyone can provide some suggestions for a problem I have. I don't know if what I'm trying to do is even possible, as I can't find a specific example on the forums or in my Access 2000 Bible.
I have a Main form (frmQuery) and Subform (frmQuerySub).
The Main Form has a combo box (cboQuery) which has a value list of premade querys (qryAllContracts, qryAllByDate etc bound to column 1 as a value list). What I would like to do is change the recordsource of the subform based on the query selected from the main form combo.
The AfterUpdate of the combo box is set to the following:
Any suggestions would be greatly appreciated, and hopefully as I build my knowledge I'll be able to return the favour to other forum members
was just wondering if anyone can provide some suggestions for a problem I have. I don't know if what I'm trying to do is even possible, as I can't find a specific example on the forums or in my Access 2000 Bible.
I have a Main form (frmQuery) and Subform (frmQuerySub).
The Main Form has a combo box (cboQuery) which has a value list of premade querys (qryAllContracts, qryAllByDate etc bound to column 1 as a value list). What I would like to do is change the recordsource of the subform based on the query selected from the main form combo.
The AfterUpdate of the combo box is set to the following:
Private Sub cboQuery_AfterUpdate()
Me.frmQuery!frmQuerySub.Recordsource = Me.cboQuery
EndSub
However I receive "Compile Error - Method or data member not found" with me.frmQuery being higlighted in the vba debugger.EndSub
Any suggestions would be greatly appreciated, and hopefully as I build my knowledge I'll be able to return the favour to other forum members