How to use Where condition in Macro Access 2010 for two fields

[coolwhisper]

Dear All,



I need to make a filter by using Macro in Access 2010

To do this I need to use two fields to get the result.

So in "Where Condition" I should put an expression belong to the poth of the fields.

I now how to use "Where condition" but only for one field like below :

="[TabReq_No]=" & [Text2]

Can you help me please ?

Kind regards & many thanks

[pbaldy]

Along the lines of:

="[TabReq_No]=" & [Text2] & " And [OtherFieldName] = " & [SecondTextbox]

[coolwhisper]

Many thaks pbaldy
This great and it works

have a good day

[pbaldy]

Happy to help!

[coolwhisper]

Dear pbaldy

I got a problem again with this :


IsNull([CText2] And [CSecondTextbox])

It's for two Texts but doesn't work with me !!

[coolwhisper]

IsNull([Text2] And [SecondTextbox])

[pbaldy]

Test each separately with IsNull, not together.

[coolwhisper]

sorry it works with me now

IsNull([Text2]) And IsNull([SecondTextbox])

Good