>>>>>>>>> How to Setvalue * Or Null expression <<<<<<<<<<<<

[JOJ via AccessMonster.com]

Hello to all
I have been using MS Access 97 for quite some years.My setup is
MS Access 97 with sql server 2000 back end with ODBC.

Pls. see my conditional macro below which update [Forms]![All Shipment
Status]![dtclose1a] based on
a condition and I am using this parameter as a query criteria.In the first
condition it is filled with a date value and second condition it is expected
to be filled with "*" or Is Null.

flagclosebydate1 [Forms]![All Shipment Status]![dtclose]<>#01-01-05#
(1st Condition)
SetValue
Action
[Forms]![All Shipment Status]![dtclose1a]
Item
DateValue([Forms]![All Shipment Status]!
[Dtclose]) Expression
--------------------------------------------
-------------------------
[Forms]![All Shipment Status]![dtclose]
=#01-01-05# (2nd Condition)
SetValue
Action
[Forms]![All Shipment Status]![dtclose1a]
Item
"*" & " Or " & "Null"
Expression

My query criteria is Like [Forms]![All Shipment Status]![dtclose1a]

It works for the first case ie., for a specific date and does note work
for the second case which is to
display all dates including null values.

Pls. advise me how to set the value to fill up the text box so that I
can use the same query to filter all dates including nulls / specific
date.