Another list box question

[benniesanders]

I have a list box in a form. The data in the list box is a field named CTYPE from a table called Category.

I've also built a report. In a perfect world, when the user chooses one or more items from the list box, the report will only show the items in the report they have chosen. For instance, if from the list box they choose
CONCRETE and BEAM, I'd like the report to only return the records associated with CONCRETE and BEAM. Currently I'm nowhere. Here's what I have in the criteria of the query of the report in the CTYPE field:

[forms]![frmPartsListing]![lstPartsListing]

But when I run the report without the above, it runs fine, it just returns everything.

I created a button on the ListBox form with the open report code, but that's all I have in there. I'm sure ths is very simple and I"m starting to feel like a complete idiot. I've been working on this all day.

Any help would be greatly appreciated. Thanks in advance.

 

[Darrylles]

Hiya,

Try:

[forms]![frmPartsListing]![lstPartsListing].VALUE

This should select records with what has been selected in lst PartsListing.

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[benniesanders]

Thanks, Darrylle! Appreciate the input.