A2K - how do I automate clicking of a checkbox?

[Deano]

I have a subform that is populated by a table that holds lots of yes/no
values. The user sees points at the side and then periods across the top.

So they decide they want point 20 for period 5 and go click that checkbox.
This in turn fires of various calculation code in the After_Update event of
the checkbox. This all works rather well.

I now need to check a given checkbox using code. I'm attempting to create a
recordset based on the table and then changing the value that way - however
this code isn't really working. The box changes but the associated events
aren't firing once this is done. I then try to call the required code but
now I'm getting error 3197 or the data has been changed.

So it would be cool if I could change a given checkbox via code to reproduce
exactly what happens the user clicks on it.

thanks

[Jeff]

When you set the value of a checkbox in code the events don't get triggered.

Call the events just like you would a sub or function. For example your code
may be something like this -

[chkBox] = True
chkBox_AfterUpdate

This will execute the code in the event just as if you clicked on it.

Jeff

"Deano" <de***@mailinator.com> wrote in message
news:43**********************@ptn-nntp-reader02.plus.net...

I have a subform that is populated by a table that holds lots of yes/no
values. The user sees points at the side and then periods across the top.

So they decide they want point 20 for period 5 and go click that checkbox.
This in turn fires of various calculation code in the After_Update event
of
the checkbox. This all works rather well.

I now need to check a given checkbox using code. I'm attempting to create
a
recordset based on the table and then changing the value that way -
however
this code isn't really working. The box changes but the associated events
aren't firing once this is done. I then try to call the required code but
now I'm getting error 3197 or the data has been changed.

So it would be cool if I could change a given checkbox via code to
reproduce
exactly what happens the user clicks on it.

thanks

[Deano]

Jeff wrote:

When you set the value of a checkbox in code the events don't get
triggered.

Call the events just like you would a sub or function. For example
your code may be something like this -

[chkBox] = True
chkBox_AfterUpdate
Thanks the only worry I'm left with is determined which row they've selected
for a given column. I'm trying to adjust my existing code still to get this
done, can't believe it can't be done.