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?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.