only show results in report

[EGTax]

Hello all,



I wrote a pretty simple inventory database for my office, which does what i need except the report, i have a couple filters that i use to show only parts of the report, but i need to figure out how to make the report only show what i filter out..



the 2 filters are office number and category, so when i use them like so:



but when i click on report, it only has every record in the report.

For the report i ran the report wizard and then changed the design a bit, so i am sure i have to set some parameters somewhere, but im not sure how.


any help on this is appreciated.

Thank you,

Bob

[ranman256]

build the 'where' clause, then show report:

'----------------
sub btnReport_click()
'----------------
dim sWhere as string 


sWhere = "1=1"
if not IsNUll(cboCat) then sWhere = sWhere & " and [Catagory]='" & cboCat & "'"
if not IsNUll(cboOffNum) then sWhere = sWhere & " and [officenum]='" & cboOffNum & "'"


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

[EGTax]

Thank you, This was exactly what I was looking to accomplish!
Much appreciated!