I have a form with a grid and a textbox. On the forms .Init the textbox .Value=DATE() and the table is filtered with, SET FILTER TO Date = DATE().

In the .Valid of the textbox I have the following:

SELECT Cmessage
SET FILTER TO Date = This.Value

ThisForm.GrdMain.Refresh

When I type a valid date in the textbox like 2001.06.27 I get an Operator/Operand type mismatch error on the ThisForm.GrdMain.Refresh line.

There is no code in the grids .Refresh event.

Any thoughts?