L
Leo
Hi,
How I can make parameter query which asks user for either Null or not Null
values (only two options) and then assign this parameter to a control on a
form as dialog for inquiry, to run the form or report afterward??
Lets give you more details;
I have a form which its main form is only to aks user for any Account # and
based on that Account # , the subform is filtered by assigning the Combo box
value to it underlying query parameter [Parameter Account] =
Forms![MyForms].ComboAccount.
Now I need also aks user if he/she wants to look in to only Transactions
with Voucher No. or All Transactions (with or Without Voucher No) by putting
a parameter in that unerlying query (a query that runs for subform) and
assigning it to a control (such as option button) to choose between Null or
not Null values.
How Can it be done?! please help!
How I can make parameter query which asks user for either Null or not Null
values (only two options) and then assign this parameter to a control on a
form as dialog for inquiry, to run the form or report afterward??
Lets give you more details;
I have a form which its main form is only to aks user for any Account # and
based on that Account # , the subform is filtered by assigning the Combo box
value to it underlying query parameter [Parameter Account] =
Forms![MyForms].ComboAccount.
Now I need also aks user if he/she wants to look in to only Transactions
with Voucher No. or All Transactions (with or Without Voucher No) by putting
a parameter in that unerlying query (a query that runs for subform) and
assigning it to a control (such as option button) to choose between Null or
not Null values.
How Can it be done?! please help!