Strange Error..

[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

 

[John W. Vinson]

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

Your message says there's a control named "bal2". Your DLookup does not
reference that control. It looks up a field (not a control!!) named Balance,
referencing a form control named ID1.

What's bal2 got to do with it?

I'd a) avoid using blanks in table or query names and b) if you must enclose
the name in square brackets, e.g. "[STUDENT BALANCE]".

John W. Vinson [MVP]