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
Is there are way to check for visibility on a control before running the criteria:
IIF Forms!myfrm!drivers.visibl
Microsoft AccessVBASQL
Last Comment
Ernest Grogg
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
IF Forms!myfrm!drivers.visibl
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.