Strange Error..

  • Thread starter Thread starter K90267000 via AccessMonster.com
  • Start date Start date
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
 
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
Click to expand...

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]
 
Back
Top