gwallace1
Oct 20, 2008, 02:54 AM
Ok.. see if I can ask this correctly... I have an option group with 8 values. Each value has corresponding text I need in one report. To do this the option group is unbound. I used VBA code with a case statement to update a new text box bound to the option group and a case statement for the form to save (convert back) the text from the bound text box back to a value so the form record updates... All works great except I have a second report that originally had an identical option group bound to the first... but it is unbound now... silly, but can I do both... without a ton of coding? One report with text and the other basically copying identically the original option group in the form?. or I can just be simple and bind the second report text box just like the first... but that would not be challenging at all.