Filter Report based on Multi-Select Listbox

[bstboy]

Forgive me, I don't know much code and looking for some help. Access 2007 WXP user.

As the title says.

Listbox is called Brandlist
Command Button is called Command12
Report is called Inventory$Crosstab

Field which will be the filter is called [Brand]

I've tried other codes posted on other forums and I keep getting a syntax error in which I wouldn't know what to do, probably because the codes I've looked at are for older versions of Access.

Any help is appreciated.

 

[Alansidman]

Is the record source for your report a table or query?

crosspost

http://www.mrexcel.com/forum/showthread.php?t=587447

 

[bstboy]

The source of the report is a crosstab query

 

[Alansidman]

Post your SQL statement for your crosstab query. Does your listbox query contain more than one field. ie. an ID field and a description field? If so, are you referencing the ID field in the crosstab query?