Loading textbox value from form into query problem

[hardrock]

Hi all,

I have a query that is basically loading values from a open form.

Im using the format of Product: Form!form1!products to assign the value of products to product in my query... Now all this works with straight text, however this technique does not appear to work with dates or yes \ no check boxes. I have used the builder but still wont work with dates. any ideas? thanks

 

[Moniker]

Text takes single quotes '
Dates take pound signs #
Numbers get no qualifiers

Therefore:

'MyTextValue'
#MyDateValue#
MyNumberValue

And:

SELECT '" & MyTextValue & "'"
SELECT #" & MyDateValue & "#"
SELECT MyNumberValue

As a tip, checkboxes are numeric. -1 equals True and 0 equals False.