Form from Crosstab Query: Combo Box

[progenysend]

I've got a crosstab query that's being displayed in a form. I need it to display data only for certain managers based on a combo box. Here's the code:

Private Sub cmbMSCManagerDisplay_Click()
Me.MSC_CrosstabAPI.Form.Filter = "Managers.ID=" & "" & ""
Me.MSC_CrosstabAPI.Form.FilterOn = True
Me.Refresh
End Sub


cmbMSCManagerDisplay is the Combo Box
MSC_CrosstabAPI is the form
Manager.ID is the field being filtered

I keep getting a Compile Error saying Method or data member not found. MSC_CrosstabAPI is what is being highlighted.

This same code has worked other places, but it's not working here. I'm a Crystal Reports developer, but not that good with Access and VBA.

Thanks

 

[PHV]

Why not simply use Me.Filter ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[progenysend]

Because, like I said, I'm not good with Access or VBA. I don't know what that is. Thanks for the suggestion.

 

[progenysend]

Either I'm using it wrong, which is very possible, or this isn't working for my needs. I'm pulling multiple records based on the selection in the combo. I still can't get past the compile error.