Error # is shown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to display a value from a query but I get "error #" appear instead. The value is a countof from a query. Any idea? Tried converting it to a string and i then get Error 0
Thanks
 
I suspect the calculated textbox is named the same as a
data element in the underlying query. When you use a
calculation (any time you type "= " in the text box you
must make sure that the textbox is not named the same as a
data element in the underlying table or query.
Now, when you rename the textbox make sure that your
original formula has not been updated also.
Hope this helps.
Fons
-----Original Message-----
I am trying to display a value from a query but I
Click to expand...
get "error #" appear instead. The value is a countof from
a query. Any idea? Tried converting it to a string and i
then get Error 0
 
Back
Top