Criteria from a Listbox In Crosstab query

  • Thread starter Thread starter Robert Wainwright
  • Start date Start date
R

Robert Wainwright

I am trying to use a selected value from a listbox in a
crosstab query. When I run the query I get an error that
says "The Microsoft jet database engine does not
recognize '[Forms]![frmDgEnter]!lst[DG]' as a valid field
name or expression.". If I switch the crosstab query back
to a select query the query will work. I am bit perplexed
and have tried a number of possible solutions. I did
use "Where" in the total column. If anyone else has run
into this issue and has a resolution please let me know.

thanks for your help,

Robert
 
Hi,


In a crosstab, we must define the DATA TYPE of each parameters. From
the query designer menu, it is under Query | Parameters... In the list,
supply the exact parameter name, [Forms]![frmDgEnter]!lst[DG], I assume, and
the data type it must be.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top