Multiple null defaulted triple states change to no unwantingly 1

[hansdebadde]

I have several triple state check boxes that default to null but when I change one of the them, they all then change to no. Any ideas on how I can keep them defaulted to null? I am using Access 2003
Thanks in advance

 

[Remou]

Can you give a little more detail? For example, is the form a single form or a continuous form? Are the Check Boxes bound or unbound?

 

[hansdebadde]

thanks, its a single form and the check boxes are bound. There is one source table for the whole form. The check boxes refer to different fields in the table that are integers

 

[Remou]

I'm afraid I cannot reproduce this problem (I have Access 2000). I guess you have checked the Control Sources for the checkboxes. :-(

 

[MajP]

You can not. Access does not support triple state. They are all defaulted to 0. What is happening is a new record is being created so it looks like they are all being clicked.

 

[MajP]

Oops. I confused myself with something else. Set the triple state property to yes, and the default value to null on the control property.

 

[hansdebadde]

I did set the triple state to yes and the default to null and when I first open a new record all the check boxes are null but when I change on of the them to yes or no all the other ones turn to no. How do I stop the others from changing?

 

[MajP]

If these are integers your table by default is set to zero for these values. Check the default value in your table, leave it blank or null.

 

[TheAceMan1]

How are ya hansdebadde . . .

[blue] . . . its a [purple]single form[/purple] and the [purple]check boxes are bound[/purple].[/blue]

Sounds like you have [blue]code somewhere taking over![/blue] If not, then I'd say you have [blue]some kind of corrutption![/blue] . . . [purple]check you code for routines affecting these controls . . .[/purple]

See Ya! . . . . . .

 

[hansdebadde]

Thanks MajP I forgot to also set the table default to null. That was it. I am an idiot, I should have thought of that but...

The AceMan1 cometh! Thanks AceMan, the corruption is not in the database....heh heh

Hey AceMan how do you insert the quote from my post?

 

[PHV]

how do you insert the quote from my post?
To get this:

. . . its a single form and the check boxes are bound.

type this:
[ignore]

. . . its a single form and the check boxes are bound.

[/ignore]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886