If I use a statement like the one below I can open my database.

SELECT myFields
FROM myTable
WHERE dDate = DateValue('9/22/2000')

How can I open it with a value entered in a textbox. I tried
myDate = Text1.Text
SELECT myFields
FROM myTable
WHERE dDate = DateValue(myDay)
but it didn't work. How do I do it?


[Edited by kokopeli on 09-22-2000 at 02:41 PM]