Recent content by rockb

Thank you.

VBA Thank you for the quick reply. I am all for a simple solution. I tried docmd.openreport "ScansOnDate, acViewReport, , "[Scandate] = #" & me.list22.column(0) & "#" and [ScanDate] is highlighted with error of expected end of statement.

I have a button on a form that displays a report that is based on a query. That query currently has a criteria that prompts the user to enter a date. What I would like to have happen is the user be able to select a date from a list box that is on the for mentioned form. I already have that...