Filter report inside a form

[aceSoft]

Hello there im searching for code where i can filter a report that is placed inside a form.
Normally in opening a report the code is Docmd.OpenReport,,, however in my case the report is already inside my form and
im suppose to hit a button to apply filter on it. Can Anybody guide me o please.

1. I have a Report inside a Form
2. I have a Dropdown Menu to select Item on it (Once Selected)


3. I will hit a button to apply filter and show it on my Report inside that form.

Im in need of a code where i can filter that report and reload data on it. thank you. kindly please help.

[ranman256]

If cboBox has the data to filter...

If Not IsNull(cboBox) then sWhere ="[field]='" & cboBox & "'"
Docmd.openreport "rMyReport", acVeiwPreview,,sWhere