Access Tick box

[Inaccessable]

This is probably very simple but still beyond me.

I have a table that stores text in a number of different languages. Each entry has a unique ID number. Each language version of the same text shares the ID number.
I have a column of tick boxes that show where this text is used.
ie
1.0 English_text_re cord_1 tickcol1=y tickcol2=n tickcol3=y
1.0 French_text_rec ord_1 tickcol1=y tickcol2=n tickcol3=y
1.0 Spanish_text_re cord_1 tickcol1=y tickcol2=n tickcol3=y
2.0 English_text_re cord_1 tickcol1=y tickcol2=y tickcol3=y
2.0 French_text_rec ord_1 tickcol1=y tickcol2=y tickcol3=y
2.0 Spanish_text_re cord_1 tickcol1=y tickcol2=y tickcol3=y

I am trying to set the tick boxes so that, if I tick one in an ID range, all the rest tick on as well. ie if I tick record 1.0 English tick_col_2, then the French and spanish will be ticked as well.
Any suggestions will be greatly appreciated.

Andy

[marcf]

depends on what you are actually ticking, if your ticking the field directly through a datasheet view or if you have tick box controls, for me the sql statement would be:

UPDATE <table> SET tick1=true,tick 2=true,tick3=tr ue,tick4=true WHERE <idnumfield> = <current record idnum>

If you can give more idea on the type of form your using etc I can probably give you an easy solution.

Cheers

marc