Going nuts!! (97/2k)

Topic

New Reply

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.
Locked as duplicate post – please respond to post 189721 – – – WendellB 19-Oct-02 06:25 MDT

Reply | Quote