John W Colby
jwcolby at gmail.com
Tue Feb 4 13:32:29 CST 2014
John, I need more information before suggesting a solution. 1) How many text boxes? 2) How many groups? 3) Bound or unbound forms / controls? Before you do anything, you need to decide on the data storage method. 1) One big record with a field for each answer for all three groups. Works OK if the questions are carved in stone. Yea right. 2) Three tables, one for each group, designed like #1 above. 3) A record for each answer (probably the "best" solution) with an FK back to the question being answered and another to the "person" record of the test taker. I tend to think code in OO. IOW this is not a form but a process where the form is an interface to the process. I will just throw a couple of ideas out. Given three groups of questions, 1) you could do three subforms. 2) You could do three tabs 3) You could do three containers 4) You could do all the text boxes in one big mess. The reason I ask all of this is to discover how complex the code behind the form is going to be. I despise forms with a mile long printout of code, with two hundred event handlers, the same thing over and over for each control of the same type. John W. Colby Reality is what refuses to go away when you do not believe in it On 2/4/2014 9:22 AM, John Clark wrote: > I feel like I'm missing something though Arthur...what command/code do I use? I'm thinking along the lines of a WITH statement, but that won't exactly do it, if I'm thinking correctly. > >>>> Arthur Fuller<fuller.artful at gmail.com> 2/4/2014 9:15 AM >>> > Probably you want one of the groups to be visible by default. First of all, > give all the controls within each group a similar name, such as > grp1TextBox1. That will simplify handling them. Then make all the grp2 > agrp3 controls invisible. After that it's simple to handle them in your > AfterUpdate event. > > HTH, > Arthur > > > On Tue, Feb 4, 2014 at 8:53 AM, John Clark<John.Clark at niagaracounty.com>wrote: > >> I was actually going to ask a similar question this morning... >> >> I have essentially 3 groups of questions, and I'd like to present one of >> these groups, based on the value of another field. And, I was wondering if >> I could group them and do it that way. I was even thinking about giving the >> fields a certain naming convention to do this... >> >> So, it is good to know it can be done. BUT...I'm still a bit shaky (to say >> the least) on how to carry this off. >> > Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. > IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. > Thank you for your cooperation. > >