Query won't grab currency from text box 1

[darylclassen]

In Form1, I have a currency value as the default value in a text box that has been grabbed from a text box in another form. My problem is that I keep getting a messed up response when I send this value to my query. Instead of the value, I get 2 little boxes. I assume this is because Access is messing up the types (currency as text)but I can't figure out what to do about it. Any ideas?

PS.I don't want the value linked to the original table, because I want the user to be able to manually adjust it's value if he wants without adjusting the underlying value in the table it's pulled from.

 

[jsteph]

Probably the "$" is being interpreted as a non numeric character. Try setting the texbox format to currency and then it should just take a normal number but show the $.

Otherwise try saying in the query: CCur([txtBox])
--jsteph

 

[darylclassen]

Thanks so much, that totally solved my problem!
Cheers