If I don't get help with checkboxes & tabs I may turn into a werewolf!

[thechangling]

I have a tab control set up with check boxes on it. It works except every time I click a box on one record/person's info. it carries over to all the other records. How do I get it to stay with just the one record? I have about 2000 names to go into this database, with several different tab controls containing check boxes in each.

My bark is always worse than my bite, except during a full moon!
Okay, more info! I have a database which I use for keeping track of members/people. In order to keep up with which internal groups these people are members of I have set up tab controls on the main form. The first tab is where I put the check boxes to note what profession members are in. But when I put a check in the box for doctors on one person's record, it shows up on everyone's records. I'm new at some of this so I apologize if I don't always explain this really well. But if you ask the questions I'll do my best to answer them. Thanks!

[This message has been edited by thechangling (edited 10-31-2001).]

 

[Rich]

Will your bark be worse than your bite? We could do with a little more info here, structure etc.

 

[SteveA]

It sounds like the Checkbox is unbounded (doesn't have a recordsource. If a field is unbounded the value will carry through to every page but is not actually being saved anywhere. If you want to save the value for each record you need to link it to a field in your underlying table.

HTH
SteveA

 

[Dobie]

Set a field up in the table and set its values to a yes or no option. then on your form link the check box to that field. Now when you check the box it wont change all of them.