How do i program an option button?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top