Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Option Group (https://www.askmehelpdesk.com/showthread.php?t=271343)

  • Oct 20, 2008, 02:54 AM
    gwallace1
    Option Group
    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.
  • Oct 20, 2008, 06:42 AM
    ScottGem

    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.

  • All times are GMT -7. The time now is 10:52 PM.