Update checkbox on a Continuous Form

[vulcaned]

Hi All,
Hopefully I explain/ask my question correctly;

In Access97 on a continuous form I display records direct from a table.
Two displayed fields are policy nbr and a approved checkbox.
In the displayed records I could have multiples of any given policy
nbr. What I am hoping I can program is when a user clicks in the
approval checkbox(makes it true) I then want to check off the rest of
the approval boxes for that Same policy nbr that is in the set of
displayed records.

Can that be done programmically(vba)? if so, what does the code look
like.

thanks
bobh.

[rquintal]

>What I am hoping I can program is when a user clicks in the

approval checkbox(makes it true) I then want to check off >the rest of the approval boxes for that Same policy nbr that is in the >set of

displayed records.

In the AfterUpdate event for the form, you need to run a query that
sets the field true, something like

if me.approval = true then
docmd.runsql("Update [tablename] set [checkfieldname]= true where
[policy nbr] = " & me.[policy nbr])
end if

[vulcaned]

Thanks, with a tiny bit of addition(namely, before running this code I
had to set the focus off of the detail section of the continuous form)
your suggestion worked perfectly, again Thanks
bobh.