control source not working.

[romio]

I have created my query based on a table in order to find how many data are in the list, then I have added a textbox in one of the form and I added this line in the control source:

SELECT AcademicAudioCount.Total FROM AcademicAudioCount;

This is what I get: #Name?

But its not working, any help.

Thanks.

 

[pbaldy]

You can't use an SQL statement as the control source of the textbox. The simplest solution for you is to use a DLookup() function to get the value from the query. It's hard to say without seeing the query, but you may not need it at all. You may be able to get the same result with a DCount() function.

 

[romio]

Thanks pbaldy, I did some search and I found the way to do it, I just simply added this line it is a bit slow but it seems to be working:

=DLookUp("[Total]","AcademicAudioCount")