Multiple filter options for a report

[bfg]

I have a report listing student achievements but I would like to include a filter with multiple options, eg filter the report by 'Free school meals students' OR 'Special Educational Need students' etc. Is there a way of allowing the user to choose the type of filter the user wants before the report runs and lists the resulting data.

I don't particularly want to create a separate query for every possible option of filter choice as that could result in dozens of near identical reports being saved.

Hope this makes some sense.

[Bob Fitz]

If you use VBA code to open the report you can set criteria to restrict the records shown. See Docmd.OpenReport: https://docs.microsoft.com/en-us/off...cmd.openreport
You will need to give the user something that can be used to select the criteria and then build the argument used by Docmd.OpenReport

[bfg]

Thanks for the rapid response Bob. I will try this out later today. I've never really got in to using VBA but the link you provide looks fairly straightforward...famous last words

[Bob Fitz]

Thanks for the rapid response Bob. I will try this out later today. I've never really got in to using VBA but the link you provide looks fairly straightforward...famous last words

Ha! Ha! Post back if you need more help

[orange]

You may find some options at this site (part of Martin Green's Dynamic reports) - which has been removed from its original location.

[ranman256]

sub btnFind_click()
dim sWhere as string

sWhere = "1=1"
if not IsNull(txtBox1) then sWhere = sWhere & " and [field1]='" & me.txtBox1 & "'"
if not IsNull(txtBox2) then sWhere = sWhere & " and [field2]='" & me.txtBox2 & "'"
if not IsNull(cboBox) then sWhere = sWhere & " and [field3]='" & me.cboBox & "'"

If sWhere = "1=1" Then
  docmd.OPenReport "rMyReport",acViewPreview
Else
  docmd.OPenReport "rMyReport",acViewPreview,,sWhere
End If
end sub