NEED Report button - I have 3 Tiered Grouping

[orangey]

my report is grouped in 3 tiers (not based on a query)
and i have a subreport in it

the button i created on a form only brings up the subreport and the main report is blank

(not to mention this weird useless box comes up that i have to click 'ok' to)

what i want is to select the top tier group from a form and have that report show based on the selected group.
______________________________________________
Private Sub Command8_Click()
Dim stDocName As String
Dim strWhere As String
stDocName = "New_Table"
strWhere = "[group_name]=" & Me!group_name
DoCmd.OpenReport "New Table", acPreview, , "[group_name]=" & [group_name]


End Sub

________________________________________
is not working for me....


Garridon, I've seen your post too many times...

 

[HiBoo]

Assuming that the report is set up correctly you might only want to modify your filter string so that it filters a string properly...


strWhere = "[group_name]='" & Me!group_name & "'"

Hope this helps.