If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Option group selection as query criteria
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 |
#2
|
|||
|
|||
Option group selection as query criteria
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 -- Duane Hookom MS Access MVP -- "Tara" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|