Change value of checkbox at runtime (using VBA)

[febad]

Hello,

I will like to change the value of a check box at runtime. I have a
database with a field "multiple_print _select", which stores a value of
"1" when it is checked so that the record can be printed.

This allows only the records selected to be printed, but wen another
set of records are selected again, the previous selection are still
true, so the records are reprinted which I need to prevent.

So, I'm thinking of changing the value of the checkbox at runtime: For
instance, a VBA code that will set the value of the checkbox to "0" on
closing the report or a better way of doing this.

You help will be highly appreciated.

Regards,
febad

[Linq Adams via AccessMonster.com]

Re: Change value of checkbox at runtime (using VBA)

A Checkbox will ***never*** have a value of 1. If checked its value will be -
1, if unchecked its value will be 0.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com