Multiple where condition (numeric + string)

[Capitala]

Sorry for disturb!
I need to open a report from a current form with two where conditions; first is numeric and the second is string.
DoCmd.OpenReport ("abc"), acViewPreview , , (where condition)
Thanks in advance

 

[Capitala]

It is easiest to build complex strings in variables so you can have an easy way to print them to the debug windo if you have trouble.

Dim strWhere as String

strWhere = "fld1 = '" & Me.textfield & "' AND fld2 =" & Me.numericfield

This assumes that the text field does not contain embed single quotes. If the text field is a name then the embedding of the double quotes gets more complicated. In all my apps I create a constant named QUOTE

Public Const QUOTE = """"

Then the statement would be:

strWhere = "fld1 = " & QUOTE & Me.textfield & QUOTE & " AND fld2 =" & Me.numericfield

It works, thanks alot

 

[Capitala]

It works, thanks alot

Pat Hartman​

I appreciate a lot if you give me the syntax for: 1) two text 2) two numbers.
Sorry for bothering you

 

[Capitala]

Great! many thanks