How do I get the value of a combo box into a crosstab query?

[whodeycp]

I have a form that is using a combo box to select a year that they want to start a report and will take that year and the next four years as well. Well I want to take the value that is selected in the combo box and use it in a crosstab query. I have never really used crosstabs before and it keeps giving me the error "The Jet Database Engine does not recognize '[Forms]![frmReportLookUp]![cboFindReport]' as a valid field name or expression". The cirteria I am putting in the query is >=[Forms]![frmReportLookUp]![cboFindReport] And <=[Forms]![frmReportLookUp]![cboFindReport]+4 to get the additional four years after the value selected. Can anyone help?

 

[TheAceMan1]

How are ya whodeycp . . .

. . . and this:

[blue][[purple][b]FieldName[/b][/purple]] >= "#" & [Forms]![frmReportLookUp]![cboFindReport] & "#" And [[purple][b]FieldName[/b][/purple]] <= "#" & [Forms]![frmReportLookUp]![cboFindReport]+4 & "#"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[PHV]

In a crosstab query you have to defines the parameters:
menu Query -> Parameters

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