I don't know all the details of what you need exactly, but from what it
sounds, all you need is a checkbox in an access form. It is a form you're
working on, right?
Open a form in design view, and click on the Check Box tool in the toolbox.
If you cannot see the toolbox, right-click anywhere on the form and select
the 'Toolbox' option, or select it from the form design toolbar. The icon
looks like a hammer and a wrench crossed.
When you have the tool selected, left click and drag to create one on the
form. If you want to link it to a table column, right click on it and select
Properties. Under the All tab, set the Control Source to whatever you want
the check box to represent. Easiest way to do this is use the drop-down box
and pick one. I think you can only select true/false datatypes for the
checkbox.
If you want to reference the checkbox in code, it's rather simple:
if checkbox1 = true then
checkbox1 = false
else
....
I hope that's answers your question. I have a feeling I might have missed
the boat entirely though.
Nick