Crosstab Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a select query that refers to a control on a form i.e. [Forms]![Form Name]![Control Name]. This query works fine. When I make the exact same reference in a crosstab query I get an error message saying: The Microsoft Jet database engine does not recognize my reference as a valid name or expression. Puting my form reference in the Query Parameters dialog box eliminates this message but my query still dosen't work. What do I need to do?
 
I think I have answered this same question 2-3 times this week already in
this news group. You need to menu select Query|Parameters and enter
[Forms]![Form Name]![Control Name] {select its data type}

--
Duane Hookom
MS Access MVP


Steve said:
I have made a select query that refers to a control on a form i.e.
Click to expand...
[Forms]![Form Name]![Control Name]. This query works fine. When I make the
exact same reference in a crosstab query I get an error message saying: The
Microsoft Jet database engine does not recognize my reference as a valid
name or expression. Puting my form reference in the Query Parameters dialog
box eliminates this message but my query still dosen't work. What do I need
to do?
 
Back
Top