PDA

View Full Version : Option Group


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.

ScottGem
Oct 20, 2008, 06:42 AM
You can do this without ANY coding at all. Simply create a lookup table for the values. Then change your key field to an integer field and bind the group to that field.

To do your reports, base the report on a query that joins to the lookup table and pull the text field into the report.