Access 2010: issue with Control source and #Name error

[access321]

Hi

I am trying to use a count function copied from a query ( Number of spares - SafeCaptureHDs ) into an unbound text in an Access 2010 form:



Control source entry via the Data tab ( Property sheet ) :

=[Number of spares - SafeCaptureHDs]![CountOfBox Type]

I receive a '#Name' error when I open the form.

Do I need to change some properties in the Property sheet?

[pbaldy]

If you're saying that query is not the record source of the form, you'd have to use DLookup() or some other method to get the value.

[access321]

If you're saying that query is not the record source of the form, you'd have to use DLookup() or some other method to get the value.

Thanks for getting back to me.

I haven;t used dlookup in Access before, please would you show me how i would go about doing that.

[pbaldy]

=DLookup("[CountOfBox Type]", "[Number of spares - SafeCaptureHDs]")

You'll find in the long run that the spaces and symbols in your names aren't worth it.

[access321]

=DLookup("[CountOfBox Type]", "[Number of spares - SafeCaptureHDs]")

You'll find in the long run that the spaces and symbols in your names aren't worth it.

Thanks, Paul.

[pbaldy]

No problem, and welcome to the site by the way!