Afkryds mange fleter

lav en opdateringsforespørgsel enten på baggrund af den tabel eller forespørgsel hvor feltet er med o g træk dit ja/nej ned og opdater det til 0 mener jeg ellers er det -1

det er -1

in the debug window (Ctrl+G) write the following changing the table and field names as needed.

DoCmd.runsql \"UPDATE YourTable SET TheField = -1\"

Jeg mener feltet skal defineres som tabelnavn.feltnavn som i nedenstående eksempel, hvor Personregister er tabellen og Ødeltager er feltet.

DoCmd.RunSQL \"UPDATE Personregister SET Personregister.Ødeltager = False;\"

Husk derefter i tabellen, at sætte standardværdien for nye poster i afkrydsningafeltet til False (-1).
False = Nej = -1
True = Ja = 0

Hi mugs!
first it is NOT necessary to prefix the field name with the table name when there is only one table, what else could it be than that table?

Next:
True is -1
False is 0

So there is NOTHING wrong with my SQL :o)

Oh I forgot!
Checked (afkrydset) = True, so as far as I can see there is no need to alter standard value if it already is false, as dsb states himself!

Hi Terry!
Where do You see, that there is only one table in the db?
False / True = xx, Ok You win
I mentioned the \"Standardværdi\", becaurse it seems to me, that dsb does not know what it is. But by knowing this dsb has the possibility to change it if He wants. :o) 

Hi mugs!
Well I cant see how many tables there are in the DATABASE, but (reading between the lines) I am assuming that thats what he means :o)

mugs>I came to think of this question just as  Iwas crawling out of my bed.
In my comment 20:18 I sain only one tabel, nothing about in the database. Infact there could be many in the database isself, but if ther eis only one in the query then you dont need to use the table name. Access nearly always addeds the table name but it isnt necessary.

For example:

SELECT tbl1.fld1 as Myfld1, tbl2.fld1 as Myfld2 from tbl1, tbl2

SELECT fld1 as Myfld1 from tbl1´

are both correct

dsb>Are you running on time?