Find record using combo boxes

[Cillies]

Hi, I have a form displaying information on individual rugby games.

What I want to do is to use another form to select opponent and the season to display the results on the 1st mentioned form.

Now I want to use 1 combo for the opponent and 1 combo to select the season. I just don't know how to code the find button, which should bring up a form with the selected criteria.

In the query under opponent I have included the code [forms]![formname]![cboname]and the same with season

Any help would be great. Thanks

 

[FancyPrairie]

Give this a try:

Dim frm1 As Form

Set frm1 = Forms!form1

frm1.RecordsetClone.FindFirst "PlayerID = " & cboPlayerID & " AND GameID = " & GameID
If (frm1.RecordsetClone.NoMatch) Then
MsgBox "no match"
Else
frm1.Recordset.Bookmark = frm1.RecordsetClone.Bookmark
End If