Greetings

i am having trouble with this sql statment

UPDATE Location SET Location.Location =
IIf(location!updateme=True,Forms!Series!NewLocation,location!Location)
WHERE [location];

it is changing EVERY location to the one at Forms!Series!NewLocation
instead of just the ones where updateme is true. am I missing something
in my statement or can this only be done in a vba do loop?

Try:

UPDATE Location
SET Location =Forms!Series!NewLocation
WHERE UpdateMe = True


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Greetings
>
> i am having trouble with this sql statment
>
> UPDATE Location SET Location.Location =
> IIf(location!updateme=True,Forms!Series!NewLocation,location!Location)
> WHERE [location];
>
> it is changing EVERY location to the one at Forms!Series!NewLocation
> instead of just the ones where updateme is true. am I missing something
> in my statement or can this only be done in a vba do loop?
>

i got it my where was too broad
(E-Mail Removed) wrote:
> Greetings
>
> i am having trouble with this sql statment
>
> UPDATE Location SET Location.Location =
> IIf(location!updateme=True,Forms!Series!NewLocation,location!Location)
> WHERE [location];
>
> it is changing EVERY location to the one at Forms!Series!NewLocation
> instead of just the ones where updateme is true. am I missing something
> in my statement or can this only be done in a vba do loop?