Option group selection as query criteria

[Tara]

I'm pretty familiar with a lot of the basics of Access,
but have never worked with an option group before. I
have one on a data entry form and am using it
for "coding" in a table. No problems there. What I need
to know, is can I use a selection from this same option
group as query criteria. For example, a user goes in and
adds 10 new records to the table using the option group
selection to "code" it. Then , they want to run a report
to pull all of the records that are coded "2". I have a
command button on the form itself to run the report, but
I need to use the option group to determine which records
to pull. Is this possible? If so, how should it be done?

Thanks for any help!
Tara

 

[Duane Hookom]

You can set up a similar option group on your form for the criteria. Then
set the criteria under your code field to:
Forms!frmYourForm!optYourGroup