Checkboxens 3 tilstand

Why not set the default value for the checkbox field to false (nej) in the table desging. That way you will never get the problem

Or Is Null

Hey Terry, unfortunately thats a little late :D

I want to use this
DoCmd.ApplyFilter , "gronContainerLand = " & groncontainer

but how?

When you say the Ja/Nej fied has three values you mean the field on the form not the field in the dB?
Look at  the properties for the field on the form. Make sure that the "TripleState" property is set to NO

Ja = -1
Nej = 0
Ikke valgt = Null

Kriterie:
is null or =0

Hey both of you.
The problem is that if if select -1 i get 448 record, if i choose 0 i get 501 but if i look in the table there is 25000 records :(

It is the same if i use the query builder, this is really annoying. Terry you said that select default value to 0, unfortunatly i can not do this cause i get the recordset from outside, just joining the data tables and designing a new form.

There most be somehow this can be solved.

Jaze

hmm this works so u get your points
DoCmd.ApplyFilter , "gronContainerLand is null or -1 or 0"

lol this is driving me crazy.
if I use this DoCmd.ApplyFilter , "gronContainerLand is null or 0"
it is not the right selection

thanks, didnt see your comment before now.

If there are already values in the table which are NUll then I would have thought it would be possible to update them to 0 with an update statement.
Then make sure that the default value is set to 0

i could do, Terry, but how about this
DoCmd.ApplyFilter , "gronContainerLand is null or 0"
something like that

have you tried using? If sao does it work?
DoCmd.ApplyFilter , "gronContainerLand is null or 0"

it doesn't return the right amount of records.

I cant update the table they are joined and evendough i try nothing changes

didnt you say this works?
DoCmd.ApplyFilter , "gronContainerLand is null or -1 or 0"

can you send me your dB, maybe I can see the problem?
eksperten@NOSPAMsanthell.dk

yes that line returns all the records ????

But if i use this DoCmd.ApplyFilter , "gronContainerLand is null or 0" there is missing some records.
but shouldnt the last line return all which aren't -1 ??

what about
DoCmd.ApplyFilter , "gronContainerLand <> -1"

this doesn't works returns an error
DoCmd.ApplyFilter , "gronContainerLand is null or <> -1"

Terry this seems to work

DoCmd.ApplyFilter , "gronContainerLand is null or gronContainerLand <> -1"

This seems VERY strange.

<> -1 is the same as all of those whicg are not -1, which I would have though would alos include those which are NULL.

But then if thi sgives youwhat yoy want then great :o)

DoCmd.ApplyFilter , "gronContainerLand is null or gronContainerLand <> -1"

I and also myself VERY confused, cause when I started thsi task i was convinced that it wouldn't be any prob. at all.

But now?+ there is like 20 different chkboxs to take care of :( what if one is choosed and another is not and so on....

Well long nights ahead without my beloving WorldOfWarcraft

Kan du ikke bare disable den 3'die tilstand fra interfacet, og så køre en updatequery hvor du erstatter null med false/0 ?
Et null i tabellen betyder vel at en bruger aldrig har benyttet checkboxen, det er vel det samme som unchecked ?

Mundi, 3state er deaktitiveret.
Men der kommer ofte data udfra, og jeg kan ikke hvergang køre en update på rs. :(
Jeg sidder og laver en universal form, hvor brugeren kan vælge query eller table og herefter sætte de kriterier som han/hun ønsker.

Vi lukker og slukker her guys, det vigtigste var udvalget, smid lige en linie hvis jeg skal oprette et point spm. så i kan få lidt flere som tak for hjælpen...

No need for further points here :o)