There are hundreds of ways to go about this. If you look at post #2 you will see the controls being used on the current form, the current form's Filter property.
If you want to open another form and use the values selected by the user (via the combos), I would recommend going after the other form's RecordSource. This is different than adjusting a form's Filter property.
You mentioned a query. You mentioned a form. It seems all your query needs is a WHERE clause. The following code is untested. Check to see if I have the field names correct, i.e. ID and EmployeeIDFK
What this code will do is grab the values of the combos and add those values to a WHERE clause. The WHERE clause is added to the query object. The result is assigned to the other form's recordsource.
Post your questions here. The following code is untested
Code:
Dim lngEEID As Long
Dim lngIDFK As Long
lngEEID = 0
lngIDFK = 0
If Me.cboEEID.Column(0) > 1 Then
lngEEID = Me.cboEEID.Column(0)
Else
MsgBox "Invalid EEID Selection"
Exit Sub
End If
If Me.cboPositionID.Column(0) > 1 Then
lngIDFK = Me.cboPositionID.Column(0)
Else
MsgBox "Invalid IDFK Selection"
Exit Sub
End If
'Open another form and apply the values of the combos
DoCmd.OpenForm "MyOtherForm"
Forms![MyOtherForm].RecordSource = "SELECT * MyQueryName WHERE (MyQueryName.EmployeeIDFK=" & lngIDFK & ") AND MyQueryName.ID=" & lngEEID
'You can add some code here to close the current form
'DoCmd.Close acForm, Me.Name