I have a formw ith two subforms. On the main form, to be used in calculations, is a text box that uses the sum from the variable subform and another textbox that uses the sum from teh constant subform. HOwever, not both subforms will have totals. So, how the (&^*^*(&() do I tell the code to check both and if they are not null (or empty) then do something else? I have tried testing for nulls, 0, etc, and nothing seems to work.
If Me.txtVar <> "" And Me.txtCon <> "" Then Also tried
If (Me.txtVar) > 0 And (Me.txtCon) > 0 Then Also tried
If Not IsNull(Me.txtVar and Not isNull Me.txtCOn
But when the code runs, I get an error or it runs that if statement, but I want to check to see if either one of the fields is empty. This is on an ACCESS 2003 form/subforms