Update Query "Only Update if Field is blank"

[Amy Adams via AccessMonster.com]

I have an Update query that currently populates 2 fields.

Field1:ClosedNewPtsCheckbox
Field2:Effective

Field 1 is updated to True (as it is a checkbox), and Filed 2 gets updated
to N/A.

Is there a way to use the criteria in this query to only update Field1 and
Field 2 if the table field that is being updated is blank?

For example I do not want to populate the Effective field if it has a date
to N/A, but if no date exists I would like it to update to N/A.

I hope this makes sense.

Thanks for the help.
Amy

 

[Al Newbie]

if not isdate(field2) then
field2.value = "N/A"
field1.value = True
end if

HTH

 

[Guest]

Hi Amy,

If you are using the query designer, just add the criteria "Is Not Null"
(without the quotes) to the criteria line below field 2.

HTH, Ted Allen

 

[Amy Adams via AccessMonster.com]

This is code that goes in the form correct? Not code that goes into the
criteria of the update query?

If this is true do you know any solutions to insert into the criteria for
the update query?

Thanks so much for your help. As its greatly appreciated.

 

[Amy Adams via AccessMonster.com]

Thanks actually Is Null worked for what I was trying to do. Thanks!

 

[Guest]

Oops, yeah that would work better wouldn't it. Glad you got it to work,
sorry about the typo.

-Ted