Correct syntax for updating boolean field

[Maki]

Hi. I'm trying to run an update query on a boolean field.
This is a process of normalising our dog training club membership database where I'm trying to separate all individual handler information from member table where a "member" is defined by a household. Original [tbl Members] had fields [First Name], [Surname], [First Name (2)], [Surname (2)], [Email], [Email (2)] and so on. In the new [tblHandler], I created a new field [Primary Contact], which is a Yes/No field and the handler originally was [First Name], [Surname] in [tbl Members] would have tick in this box.

It seems to run the selection part ok so I'm guessing something is wrong with

[tblHandler]![Primary Contact]=True



in the following SQL.

UPDATE tblHandler INNER JOIN [tbl Members] ON tblHandler.[Member id] = [tbl Members].[Member id] SET tblHandler.[Primary Contact] = [tblHandler]![Primary Contact]=True
WHERE (((tblHandler.[Member id])=[tbl Members]![Member id]) AND ((tblHandler.[First Name])=[tbl Members]![First Name]) AND ((tblHandler.Surname)=[tbl Members]![Surname]));

Could you please lead me to the correct syntax for boolean update? Thank you.

Maki

[LillMcGill]

SET [tblHandler]![Primary Contact]=True

[Maki]

Thank you Lill!
I see now how it is with query design view.
Much appreciated!

Maki