Combo boxes on Form not working on Query
Hi,
I am scratching my head on this one. I have a form, a crosstab query and a report.
When I hardcode the parameters on the query the report runs perfectly. When I attemp to add the combo box parameters to ethe field sin the query it will not work. The message says it does not recognize the expression or is invalid.
I tried [Forms]![Nameof Form]![name of combobox] doesn't work
I tried add the parameters explicitley using the parameters box and adding the [Forms]![NameofForm]![name of combo box] doesn't work either.
I am convinced it is syntax but don't know what else to try. I have a project due Monday and so I am really in a bad way!
ANy help would be appreciated.
|