Using SQL code with VBA event coding

[Ted]

i am using a2k.

on a certain form in my app'n, i would like to add two add'l controls. one
will be called 'LTFU' and take either "Yes" or "No". when the current record
has a "Yes" in LTFU, i would like to solve for the control called
"FollowUpDate" with a query/SQL that i've created. when LTFU is equal to
"No", then i would like to solve for the control called "FollowUpDate" with a
different query/SQL.

this is probably doable, but i am not seeing anything in their HELP
documentation.

hopefully one of the readers of this forum can offer up a tip.

 

[Ted]

i'm not really all that certain i understand klaatuu and since i'm not even
at my office desktop as i write this i'm not even able to begin to test it
out so i'll err on the side of the conservative and guess i'll just wonder
out loud. you see the query is intended to use a 'SELECT .....' clause and i
thought i'd need to assign the result of the SELECT statement to the
"FollowUpDate" control/field. what you're suggesting i don't think (in
italics) would get me what i want -- would it?

-ted