Option Group code problem please help

[simpsondm]

Is it possible through code to do.!!!. Okay here’s what I have, I have a option group of 6 check boxes named (Monitored, Other monitored, Task, TBD, Operational Issues, Web) the group name is Work Categorys. When one of these items is checked it inserts in a textbox that name (example: check Monitored it puts monitored in the textbox). This part works fine.

Now what I need it to do is also in a yes/no field for each category in may table is check that field such as Monitored or what ever is checked in my table (Table named tblmainproj) insert a check.

any help would be greatly appreciated.

DMS

 

[VicM]

D24S:

I'm assuming you have a table containing a field for each of your six categories. And that each of those fields is defined as a yes/no.

The underlying recordset of your form must contain those six fields as well.

On your form, just set the control source for each category to the field in the table.

Now there is one caveat: The underlying recordset must be from one table, or tables which have a one-to-one relationship. Otherwise you will not be able to change data or add a new record. (And I'm not really sure about the one-to-one relationship either.)

HTH,

Vic