newbie - else "don't change field value" ?

[p***@gmail.com]

fields in a table

dim genlocation
if [CATEGORY] = 4300 and [LOCATION] isnull then
genlocation = ([SITE] & " - " & [SUBCATEGORY])
else
-- don't change the [LOCATION] value --

[Auric__]

Post by p***@gmail.com
fields in a table
dim genlocation
if [CATEGORY] = 4300 and [LOCATION] isnull then
genlocation = ([SITE] & " - " & [SUBCATEGORY])
else
-- don't change the [LOCATION] value --

End If

(If you don't need to make a change, then do nothing.)