I have constructed a query which returns the number of loans of a specified video. This query runs successfully and accurately when I open the query (numavail) and the value is displayed in a CountOfvideo field. The video specified is obtained from a combo box on a form. My problem arises when I try to display the result of the query in an unbound text box on the same form. I get a Name# error.
The expression I am using is: =Dlookup("[CountOfvideo]","numavail") put into the Controlsource of the textbox.
Where am I going wrong? I seem to be chasing my own tale. Any help would be appreciated.
<font color=blue>Locked as duplicate post - please respond to <post#=189721>post 189721</post#> - - - WendellB 19-Oct-02 06:25 MDT</font color=blue>