Weirdest Date Problem

[prostheticHead]

this is the weirdest problem ever!

Im using the ActiveX controle Calander thingo to get a date and drop it into a Text box

Private Sub btnSetTo_Click()
Me.txtToDate.SetFocus
Me.txtToDate = Me.calTo.Value

    Me.calTo.Visible = False
    Me.boxTo.Visible = False
    Me.labTo.Visible = False
    Me.btnSetTo.Visible = False
End Sub

then when the user clicks on a button to a qury it opens up the quiry with this in the conditions part of Create Date

[Forms]![frmStart]![txtToDate]

now ya think this would show all Records with That Date but no
so i though what happens if i type the date into the box and not use the Calander object

It works.... EXACTLY the same text in the text box it just dosnt make sence


hopfully someone can help me!

thanks

 

[prostheticHead]

WHAT WHAT WAHT?!? Now it works.... ive been siting here for ages.. with it not working now it works 100%... i must have been doing something wrong sorry to waste everyones time