Problem Comparing Dates

[Eddy]

I am using the code below to compare dates. The first date comes from a
query supplying data to a combo box. The second comes from a table through
the query underlying the form itself. When I pause the code the value for
the first date is 12/12/2003 and the second is 9/13/04 yet this code returns
True. Both fields are Date/Time data types in there respective tables.
Thanks for the help.

Field1.Column(49) > Me!EntDate

 

[MacDermott]

You could force the compare to use date logic like this:
CDate(Field1.Column(49)) >CDate( Me!EntDate)

HTH
- Turtle