Applying a filter to a report via a button

[MowsMek]

Hi everyone,

I am sorry in advance for my english, I am french, but I will do my best to be comprehensible and not to make too many mistakes.

I created a report in Access 2013 made of 4 categories (SNGCU, date, rectification & 543#). I am trying to filter the report via multiple buttons that would open the report, show the 4 categories for a single serial number. For example the first button would be (caption:0075) and would open all the reports with 0075 as a serial number (SNGCU). The second button would be 0120 and do the same for the SNGCU 0120, etc. I tried using the following code on the click event...

DoCmd.OpenReport "HistoryRecord", acViewReport, "[SNGCU]='" & Me.Caption & "'"

But it opens the full report with all the serial numbers.

I am really really new to access and have no background in programming what so ever so if you could help me it would be much appreciated.



Thank you.

[pbaldy]

For starters you have the wherecondition in the filter argument. Add a comma before it. Second, Me refers to the form, so Caption refers to the form's, not the buttons.

[MowsMek]

So how would I write it would include the caption from the button?

[pbaldy]

Me.ButtonName.Caption

or just hard code it:

"SNGCU = '0120'"

[MowsMek]

Me.ButtonName.Caption

or just hard code it:

"SNGCU = '0120'"

It doesn't work, the report opens but it is not filtered.
It still shows all the records:/

[orange]

This material may help.

[pbaldy]

It doesn't work, the report opens but it is not filtered.
It still shows all the records:/

What exactly is your code now?