Results 1 to 1 of 1
Thread: Going nuts!! (97/2k)
2002-10-19, 11:29 #1
- Join Date
- Sep 2002
- Stafford, Staffordshire, England
- Thanked 0 Times in 0 Posts
Going nuts!! (97/2k)
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><font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>