Search Forum

[timits35]

Hi,

I have been trying to follow a video to create a search form and I am stuck. I would like to put combo boxes on a form and the results show up on the same form in a sub form. I have started with 1 and cannot get it working.

Here is my code

The combo box is cboAcademy and my subform is called frmSearchResult


I am getting an error message Compile error - Method or data member not found on the line Me.frmSearchResult.Form.RecordSource = myAcademy

Private Sub cboAcademy_AfterUpdate()
Dim myAcademy As String
myAcademy = "Select * from tblParticipant where ([AcademyIDFK]= " & Me.cboAcademy & ")"
Me.frmSearchResult.Form.RecordSource = myAcademy
Me.frmSearchResult.Form.Requery
End Sub


Ideally once I get 1 combo box working, I would like to add more, so if anyone can help with that too it would be great. They would be AND operators.
Thank you for your help
Liane

[pbaldy]

There's a sample db here:

http://www.baldyweb.com/BuildSQL.htm