K
K90267000 via AccessMonster.com
Hi all,
I have a form named "panel" and a control within it named "bal2" containing:
=DLookUp("[BALANCE]","STUDENT BALANCE","[ID1]=[FORMS]![PANEL]![ID1]")
this control show #ERROR when i open the form.
The weird part is, it "Cure By Itself" if i simply get into design mode, add
a text box, and get back to form view again ! Subsequently, when i open and
close the form, everything is fine...until....
I close the database and open again, same problem!!
Help please? Thanks!
Ken
I have a form named "panel" and a control within it named "bal2" containing:
=DLookUp("[BALANCE]","STUDENT BALANCE","[ID1]=[FORMS]![PANEL]![ID1]")
this control show #ERROR when i open the form.
The weird part is, it "Cure By Itself" if i simply get into design mode, add
a text box, and get back to form view again ! Subsequently, when i open and
close the form, everything is fine...until....
I close the database and open again, same problem!!
Help please? Thanks!
Ken