Query value of check box from a subform

[allenEd]

Hi,

I have a problem trying to get a check box value from one form, as a criteria of a query in a subform.

I have 2 forms, form 2 is a subform of form 1.
form 1 has a checkbox called chk1

In form 2, there is a combo box which has a drop down field (with two options) which needs filtering depending on whether the chkbox in form 1 is clearded or not.

I have tried making a string variable, which works in form 1, but form 2 cant refernce the vaiable from form 1.

Even if it could, how do I enter the varibale in the criteria of the query.

thanks

 

[PHV]

What is the SQL code of the RowSource property of the combo ?

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

 

[allenEd]

Hi,

It is a value list

the row source is "ORA";"SQL"


If the check box is true in form 1, I need the criteria to be ORA (then it will filter), if the check box is not ticked, then SQL.


thanks

 

[PHV]

how do I enter the varibale in the criteria of the query
Which query ?

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

 

[allenEd]

Hi PHV,

Sorry, I have attached a rough (very rough) sample of what I mean. There is a combo box. If chkbox1 is true, then I only want to to see "ORA" in the drop down, if false then SQL.

Sorry If I dont make sense,

thanks

 

[allenEd]

I have fixed it using IFF.

thanks