update with multiple conditions

[suet]

Still a novice in access query update and need some suggestions from expert out there...
I have a query that will update multiple fields based on speciefied conditions.
e.g. if a supplier is changed in the master table when compare to the one in my work table, I need to mark the vendor_change_flag to 'Y'. Then the same query will check the release date of the product and mark the release date change flg to 'Y' if value is changed. Should I be performing this type of update using VB instead of single query?

[Rabbit]

There are no problems with updating multiple fields in a single query.

[suet]

Just tried to run the codes and works ok.
Thanks.

[suet]

What about the following type of update?
update a code set to '1' if condition 1 is true or set to '2' if condition 2 is true or set to '3' if condition is true
Can all these be done in single query?

[NeoPa]

That can too SueT. Look into using Switch() or Choose() in your SQL.

Going back to your initial question though, if the update is for a single record only, and that record is already being maintained via a form, then it would make sense to handle all the updates via VBA within the form. It wouldn't make sense to update it twice.