military donut
asked on
IIF statement in SQL, .isvisible then
Hello,
Is there are way to check for visibility on a control before running the criteria:
IIF Forms!myfrm!drivers.visibl e THEN Forms!myfrm!myfield
Is there are way to check for visibility on a control before running the criteria:
IIF Forms!myfrm!drivers.visibl
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
IF Forms!myfrm!drivers.visibl e = True THEN Forms!myfrm!myfield <SomeThingHere>
ASKER
On my subform I have it set up running on a sql statement that will save the data based on the main form, but one of the controls are visible and not visible based on the criteria on the main form. So I set the sql statement to qry the data based on the main form.
So if the one control is not visible then I want the data not to do the criteria for that control and vice versa....if the control is visible then run the criteria for the control..
So if the one control is not visible then I want the data not to do the criteria for that control and vice versa....if the control is visible then run the criteria for the control..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, so doesn't look good, so i changed the format of the main form to show an ID field after the controls were updated and selected, then I am running the sql criteria on subform.