Option group selection as query criteria

  • Thread starter Thread starter Tara
  • Start date Start date
T

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
 
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
 
Back
Top