Option Box to control query to a report

[kr32]

Hi,
Have an option group on a form which control the data on a form as below

Private Sub SelectGroup_AfterUpdate()
Select Case Me!SelectGroup
Case 1
Me.RecordSource = "qryCountCheck-TI"
Case 2
Me.RecordSource = "qryCountCheck-SG"
End Select
End Sub

I just want this same data thats on the form to be on the report per option selection.
I put this on the query criteria on the Group field,as this is the field for data selection.

[forms]![Count Reconciliation]![SelectGroup]

but no luck. Am I on the right track?
Thank you
KP

 

[dhookom]

An option group returns a numeric value typically 1,2,3, or ... Does the [Group] field store similar values? If not, what are the possible values and how do they relate to the values of the option group?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016