on the open event of my form I’ve applied a macro & specified my main query as the filter plus a where condition…
[regionalDirectorCode]=Left([globalRegioncode],2) & "00"
that will help filter the form. The only problem is that my form is prompting me for globalRegionCode when it is actually a globally stored variable in the database, so why am I getting a parm box for it? I guess I’m just referring to it improperly in my where condition, help!
[regionalDirectorCode]=Left([globalRegioncode],2) & "00"
that will help filter the form. The only problem is that my form is prompting me for globalRegionCode when it is actually a globally stored variable in the database, so why am I getting a parm box for it? I guess I’m just referring to it improperly in my where condition, help!
