Form Filter with Multiple Values?

[fperri]

Is it possible to have a filter that has more than one value? I cannot figure out how to code it correctly. THe following is what I have for one value.

Me.Filter = "DATATABLE.LenderCode = '" & Me.cboLenderCode & "'"

I did this for two values but it doesn't work.....

Me.Filter = "DATATABLE.LenderCode = '" & Me.cboLenderCode & "', DATATABLE.RegionCode = '" & Me.cboRegionCode & "'"

 

[fperri]

I also tried...

Me.Filter = "DATATABLE_WHOLESALE.LenderCode = '" & Me.txtLender.Value & "' AND DATATABLE_WHOLESALE.RegionCode = '" & Me.txtRegion.Value & "'"

But I get error "2001: You cancelled the previous operation.

 

[PHV]

What is the SQL code of the RecordSource property of the form you want to filter ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886