?Name# Error

[chipymunk]

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]![CountOfCLASSNUM]

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

I used the builder so I didnt mess up on spelling. There are no aparent
extra spaces.

Chip

 

[fredg]

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]![CountOfCLASSNUM]

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

I used the builder so I didnt mess up on spelling. There are no aparent
extra spaces.

Chip

You cannot reference a field in a query using that syntax.

If the query returns just one record you can use DLookUp as well as do
this all in just one unbound control.
:
="There are " & DLookUp("[CountOfClassnum]","qrySplashCount") & "
classes in the system."