#Name? on Load

[Chip]

Hey everyone

I have a splash screen set up, that loads when the database is
loaded. When the databse loads, it has some information on the splash
screen like, how many letters are to be sent to day, or how many
classes are registrered for 2008, etc.

So each number has as text box associated with it and the Control
Source for that text box is set to the value of a count query.

example

There are <blank> classes in the system.

blanks Control source is
=qrySPLASHCOUNT

But when the splash screen loads, I get #Name? error. Where am I
going wrong?

Chip

 

[Chip]

Correction,

blank's control source is

= [qrySPLASHCOUNT]![CountOfCLASSNUM]

chip

 

[boblarson]

Chip:

You can't reference a query that way. You would need to use a DLookup with
the query to get what you want. The query should return one value and you
can get it by using:

=DLookup("[CountOfCLASSNUM]", "qrySPLASHCOUNT")
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________