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.