Checked boxes won't clear out when I add a new form

[Guest]

I created a simple Access database for entering names and addresses etc. for
a rock climbing club and created checkboxes for 4 types of rock climbing
activities (Lead Climbing, Belaying, etc.) that must be checked if applicable
as part of a liability/assumption legal requirement.

The problem is that if I check one or two of the boxes, then create a new
record, the checked boxes on the previous record also become part of the new
record. What are the properties that I should set so that a new record is
blank?

PS - I'm not a technical person - and it's a very simple database so a
non-technical answer would be super! Or, I can even send it to you to look at
if you'd like!

Thanks so much.

 

[Tom Lake]

The problem is that if I check one or two of the boxes, then create a new
record, the checked boxes on the previous record also become part of the
new
record. What are the properties that I should set so that a new record is
blank?

Are you sure the option group is bound to a field in the table? It has to
store
its result somewhere.

Tom Lake

 

[UpRider]

Lyle, I'll take a look. Sent to
davegri<isat>comcast2.2net
Change <isat> to @
change 2.2 to .

UpRider

 

[Linq Adams via AccessMonster.com]

Well, this wouldn't be an option group, since multiple check boxes can be
selected, but Tom is correct; this type of behavior occurs when the check
boxes aren't bound to a field in an underlying table.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Tom,

It makes sense and understand so I looked at the properties, but I still
didn't know the "how-to" part since this is my first foray into the Access
world. I relyed on Mr. Dave (see below) to fix it.

Thanks so much!