date criteria problem

[rs0905]

I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:

=[forms]![counselorreportmenu]![txtbegin]

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!

 

[rs0905]

NEVERMIND!

I just used DateValue and now it's working. Thanks anyway!

I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:

=[forms]![counselorreportmenu]![txtbegin]

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!

 

[Ryan Tisserand]

Here was my solution. I placed this code into the query grid under the
field StartDateFilterate1

=IIf(IsNull([Forms]![C25]![StartDateFilter]),[Date1],[Forms]![C25]![StartDateFilter])

I am trying to create a query that looks for date values that are greater
than or equal to a date value on an open form:

=[forms]![counselorreportmenu]![txtbegin]

This isn't working. The field on the form is a date format field. What can
I do to get this to work? I had a similar problem in code on a form where I
was trying to find dates greater than a string date value. Wondering if it
is a formatting issue on the returned value...?

Thanks in advance!