access 2007,
I have a crosstab query that contains a field called AccountName in one of my row headings.
I have a form with a list box containing all of the account names. What I would like to do is select an accountname from the list box then have the crosstab query use that accountname selection when it runs.
I was using something like [FORMS]![frm_Main]![Acct List] for the criteria but the error I am getting is "...the database engine does not recognize [FORMS]![frm_Main]![Acct List] as a field name or expression.
Any ideas?
Thanks - Bruce D.