mud2
04-21-2005, 08:30 AM
When I build (on the fly, with VBA) a form containing a text box, and the form is based on a Record Source SQL that is based on a table, and that contains a variable (in the SQL), AND If the variable is in the table all is well, the text box in the form shows the corresponding entry in the table. BUT, if the variable is NOT in the table the form does NOT have the text box, and tests on the content of the text box result in an error.
Confused?
Confused?