help with queries active (yes/no)

[islandboy]

Hello guys,




can you assist me on how to create a querie that will will return the field with the option active (yes/no)?

thanks.

[Ryan]

Well, I made a pop up for a friend (Yes or No) options, I used a couple macros to do it. Here is sample DB with just that in it.

Hope it helps you.

Note: The option to activate, I have set up in a form. Then from there, the options are ran from macros.
But by changing the Form Properties, you can make it look like one of the small pop up boxes that windows does soooo soo often.

In this sample, If you click Add on the customer form, the Pop up comes up. Really its just a form, with properties altered. Two boxes that runs macros, The macros are the Yes or No options.

[islandboy]

thanks for the reply Ryan,

but what i want it the query to ask fot the input "Yes" or "No" is that possible?

thanks mate

[islandboy]

thanks guys but i just found how to do it.


here it is.

Field: MyParam: IIf([Discontinued]=-1, "Yes","No")
Show: True
Criteria: Like [Enter Yes, No or *]

[Ryan]

Thats great!

Dont forget to use the Solved Tool!