By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,728 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,728 IT Pros & Developers. It's quick & easy.

Access Tick box

P: 1
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_record_1 tickcol1=y tickcol2=n tickcol3=y
1.0 French_text_record_1 tickcol1=y tickcol2=n tickcol3=y
1.0 Spanish_text_record_1 tickcol1=y tickcol2=n tickcol3=y
2.0 English_text_record_1 tickcol1=y tickcol2=y tickcol3=y
2.0 French_text_record_1 tickcol1=y tickcol2=y tickcol3=y
2.0 Spanish_text_record_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
Mar 17 '08 #1
Share this Question
Share on Google+
1 Reply


P: 17
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,tick2=true,tick3=true,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
Mar 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.