Query with multiple criteria

[echamorro]

Hi all. I need to add one more criteria to my query. Two will be taken from a combo box and third one will be from one of the fields from the query in form of a text. It is not working. Could someone help me please?

 
    'Name of report to print
    stDocName = "BARCODE SP kanban report w_trigger"
 
    'Name of query
    strQueryName = "SP kanban query"
 
    'Where part from SQL statement - this is where I have the issue
strSQL = "[Part_No]='" & Me.cboPartNumber & "'  And [Count]<= " & CInt(Me.cboQuantity.Value) & "'  And [color_name]= '" & color_name & "'"
 
     'Open report
      DoCmd.OpenReport stDocName, acViewPreview, strQueryName, strSQL
         DoCmd.Maximize
 
 
 

[MikeTheBike]

Hi

You do not say what is actually happening, but you seem to have one too many apostrophes in you criteria ie

And [Count]<= " & CInt(Me.cboQuantity.Value) & "'

this apostrophe is not required if [Count] is numeric?

MTB

[zmbd]

also you shouldn't use [Count] as a field name, it is a reserved word and will cause you issues:
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access