Dynamic Filter in Crosstab queries

T

trekgoes2malaysia

I am trying to filter a few xtab queries dynamically thru a list box
that is on a form. I have placed the following code in the criteria
row of the xtab query field I want filtered....

[Forms]![Name of form]![List box field on the form]

Unfortuately Access returns an error message saying it does not
recognize the phrase as a valid field or expression. In fact if I try
to use a parameter in the criteria row I get the same thing.. IS there
anyway to filter a xtab query dynamically?

Trek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top