Good day to all,
I'm new in ACCESS DATABASE user and i find difficulties in linking the crosstab tab query into drop down list and command button.
As you can see in my attachment, that i have a form then in my drop down list (project code)i want to filter my crosstab query by what is in current dropdown list value and i click the command button MsP then the datasheet will come up that is what i want.
But the problem is in design view for crosstab query criteria, i can input the [form]![frm RSC Project]![Combo0] but when i try to run it, it say access database does not recognize as a valid name or expression. If anayone can advice me what to do i really really appreciate it, thanks in advance.
Plaese see the attachment file.