Multiple criterias in VBA Access

[jonyquek]

How would one write a code to open a report (from a form) with 2 criterias.

1.)Retrieves data according to a combo box (I'm good on that one)

AND

2.)Is according to a specific data within a field in a table.

For example.

car - 1
truck - 2
car - 3
bus - 4
car - 5
truck - 6
car - 7
truck - 8
car - 9

I want to bring up the numbers only for say a "car".

how would I write the codes in that manner?


Thanks a bunch!

 

[jonyquek]

One more thing... can this be done in a query and then the report based off the query? Right now my report is coming off a form...