mud2
04-27-2005, 07:23 AM
In my continuing saga...I make a form on the fly, using VBA. The form design has one text box. The record source is an SQL with a variable. If the variable is found, the form opens and fills the text box with the searched for variable. If the variable is not found, the form opens, but the text box isn't opened. I want to test on the contents of the text box, but if no match is found, the text box isn't opened. So, Next work-around is:
Is there a way to (using VBA) determine if the text box has been opened? I'm not interested in the actual contents, just if, or if not a match has been found.
And thanks Killian for your very prompt answer to my previous question. One answer there is to close the form and then to rename it!
Is there a way to (using VBA) determine if the text box has been opened? I'm not interested in the actual contents, just if, or if not a match has been found.
And thanks Killian for your very prompt answer to my previous question. One answer there is to close the form and then to rename it!