Strange Error..

  • Thread starter K90267000 via AccessMonster.com
  • 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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top