S
SCHNYDES
Could use a little help with a macro of mine if someone could give me
insight. I have a form based on a query, the query has a parameter which
filters by user input. I have a macro connected to a 'button" that removes
the filter to prompt for a new entry. I need to change the back color on the
form when a value in the query meets my criteria. I have the macro set up
for Setvalue with all the right expressions for the conditions and for the
back color change itself, however I can't seem to find the right place to put
the macro on when and where to run. Any suggestions? I feel like I've
exhausted everything...the form opens once and remains open, the only thing
that changes in the information...if anyone could help with as little coding
as possible would be appreciated, thanks.
insight. I have a form based on a query, the query has a parameter which
filters by user input. I have a macro connected to a 'button" that removes
the filter to prompt for a new entry. I need to change the back color on the
form when a value in the query meets my criteria. I have the macro set up
for Setvalue with all the right expressions for the conditions and for the
back color change itself, however I can't seem to find the right place to put
the macro on when and where to run. Any suggestions? I feel like I've
exhausted everything...the form opens once and remains open, the only thing
that changes in the information...if anyone could help with as little coding
as possible would be appreciated, thanks.