Checkbox Export value to field?

[Code Agent]

I would like for a checkbox to export a value to another field.

Ex. If checkbox 1 = Yes then field name "tools" = Hammer. If checkbox 2 =
yes then field name "tools" = Screw Driver.

Is this possible? Thanks in advance for any help!!!

 

[Jeff Boyce]

Possible, yes. Necessarily, perhaps not.

It seems a bit circuitous ... if you want [Tools] to be "Hammer", why not
make it a combobox and let the user select "Hammer"? It would save you
space (and code) for the checkboxes.

Regards

Jeff Boyce
Microsoft Office/Access MVP