SEARCH WITH ( YES OR NO ) DATA TYPE (1 Viewer)

[Safari]

HI ALL

HOW CAN I MAKE SEARCH QUERY FOR 2 FILDES ( YES OR NO )

I WANT WHEN I CHOOSE 1 OF THEN GET THE RESULT FOR 1
WHEN I CHOOSE ONE THE 2 FILDES TOGETHER I GET NEW RESULT FOR BOTH

I TRIED BUT NOT WORKING

PLEASE HELP

 

[arnelgp]

see your query and the code on Tahseel and Mortad (checkboxes).
I translate tahsel and it is collection.
Mortad, i dont know.
But on your table records, i only see either 1 but not both.

 

[Pat Hartman]

The example posted in your OTHER thread showed how to do it. Did you try that example?

Where (Somefield = Forms!yourform!yourcbo OR Forms!yourform!yourcbo Is Null)

If there is a value selected, Somefield must be = that value OR if the form field is null, then the record is selected. So - pick yes, no, or NOTHING. If you pick yes/no the value must match. If you pick nothing, then that part of the condition will be true. and so it doesn't matter if Somefield is equal to the selection.

 

[Eugene-LS]

I WANT WHEN I CHOOSE 1 OF THEN GET THE RESULT FOR 1
WHEN I CHOOSE ONE THE 2 FILDS TOGETHER I GET ...

One more example for you:

 

[Safari]

One more example for you:

its amazing
thank you very much
its the best lesson i ever seen

 

[Eugene-LS]

its amazing thank you very much

I am glad that you liked it, if there is something unclear in the example, please contact me.

 

[Safari]

see your query and the code on Tahseel and Mortad (checkboxes).
I translate tahsel and it is collection.
Mortad, i dont know.
But on your table records, i only see either 1 but not both.

thank you very much