update query from option group to check box ....?

[patrichek]

Hi,
I'm trying to run an update query using the query builder in access 2k3. I want to take option 6 from my contacts table and update a check box (true) in my logoption table. I've done some searching but haven't found the answer yet.
can someone take a look at my code and point me in the right direction?

UPDATE LogOptionTbl RIGHT JOIN Contacts ON LogOptionTbl.ContactID = Contacts.ContactID SET Contacts.LogOptionGrp = [LogOptionTbl].[DoNotCall]
WHERE (((Contacts.LogOptionGrp)=IIf([Contacts]![LogOptionGrp],6,Null)));

thanks!

 

[patrichek]

I think i got it using this:

UPDATE LogOptionTbl RIGHT JOIN Contacts ON LogOptionTbl.ContactID = Contacts.ContactID SET LogOptionTbl.DoNotCall = Yes
WHERE (((Contacts.LogOptionGrp)="6"));

maybe this will help someone else.