using multiple combo boxes in a form

[bobthebuilder69]

I have a form with two combo boxes on both displaying Yes and No. (in each). How do i get a form to display the results of the query that has multiple criteria? ie. yes-no, yes-yes, no-no and no-yes.

here is the code that i have made as an attempt to solve my problem

stLinkCriteria = "[Damage repaired?]=" & "'" & Me![list6] + "[Customer charged?]=" & "'" & Me![list8]

list6 and 8 being the different combo boxes. im not so good with the code as this is one of my first times using it.
thanks
steven

 

[BNPMike]

Firstly you shouldn't be using a combo box. A combo box allows new values to be entered. So what were you thinking of "Could be", "Not telling" ? Why not use a check box?

To use multiple criteria use something like

where ([Damaged repaired? = [list6]) AND ([Customer charged?] = [list8]).