Re: How do i program an option button?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

There ought not be a "Retired Products" table. Instead there should
be a status flag in product records that indicates answers the
question: Active? yes/no, true/false. When your interest is only on
active products, filter the query by the state of that bit in the
product records. Same for inactive products.

Choose the default value for that control that equals the state that
will exist when you create new product records. That will probably be
Active/True.

HTH
--
-Larry-
--

"Rtash" <Rtash@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF1DB588-DA22-4BBC-8ED8-773ABC5E9D0A@xxxxxxxxxxxxxxxx
> How do I program an option button or a Check Box Object to save a
record in
> another table? An example would be, if a Check Box is selected on
the
> "Products" form the record would be saved in the "Retired products"
Table.
> If possible, I would like it to remove that record from the "Retired
> products" Table if unchecked in the form.
>
> Thanks,
> Rusty
>


.

Quantcast