Cross tab filter from Combo (1 Viewer)

[Access_Help]

I have a perfectly working cross tab and I want one of the filter fields to filter from a combo on one of the forms.

I am getting the error:

The Microsoft Access Database Engine does not recognize Forms![Form Name]![Comboname] as a valid field name or expresion.

 

[June7]

Post the SQL statement. Review http://allenbrowne.com/ser-67.html

 

[theDBguy]

Hi. Basically, you'll have to declare the combobox as a parameter and specify its data type.

 

[Access_Help]

Thanks guys.

something like:
Dim comboBoxText As String

comboBoxText = Me.YourComboboxName.Column(1)


Will this work in SQL view..it sounds like VBA

 

[isladogs]

You cannot reference e.g. Column(1) in query filter criteria.
In a select query you can set a variable equal to that value then create a user defined function to grab that value
Or use a tempvar.

However, as already explained, to do this in a crosstab query requires a parameter to be declared.

 

[Access_Help]

Great, thank you. It works!

PARAMETERS [Forms].[Form1].[txtCustomerID] Text (255);

 

[theDBguy]

Great, thank you. It works!

PARAMETERS [Forms].[Form1].[txtCustomerID] Text (255);

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.