Or in Where Clause MS Access Vba Code

[wardha]

Can anyone help me in Where Clause?

I have three fields Country,Product, and Year in Table Cap.
I have added Combobox in form for these field and also search button.
I want that if one combo box value is selected and search button is click it should display all record for related combo box.
....
Button Click Code:

Search = "Select * from Cap where ([Country]= '" & Me.Combo6 & "' OR [Product]= " & Me.Combo15 & " OR [Years]= " & Me.Combo25 & " )"
Me.sfrmCap.Form.RecordSource = Search
Me.sfrmCap.Form.Requery

It gives Run time error 3075.

Any help would be appreciated.

Thank you.

[DataMiser]

what is the error message?

Are both of those last two fields numeric in the database?
What values are in the combos when you get the error.

Note if those fields are numeric then searching for an empty string is not valid and would be the case if nothing is selected in the related combos.
You may need to use some If statements to modify the select based on what is selected rather than just throwing it all into the one statement.

[wardha]

what is the error message?

Are both of those last two fields numeric in the database?
What values are in the combos when you get the error.

Note if those fields are numeric then searching for an empty string is not valid and would be the case if nothing is selected in the related combos.
You may need to use some If statements to modify the select based on what is selected rather than just throwing it all into the one statement.

....


Thank you , it's solved