Records and <1
Posted on 2006-10-22
I have a form that is bound to tblGuarantor. When there are no records I get an error with txtSum. TxtSum is a sum counter.
I added a dcount of the records but still gives error of "entered an expression that has not value". I cant have it run the code
of If Me.txtSum > 1 Then because the error. How do I get around this?
If DCount("*", "tblGuarantor") < 1 Then
If Me.txtSum > 1 Then
Me.lblAdditional.Visible = True