Dear Joseph,

we very much want to help you. I only encourage you to feel free and share your code for us to point you to the right direction.

Just from the code you shared, there are a couple of issues;
1. The use of "Me" key word. In this context [i.e., a Me key word in the OnClick event], means you are setting the record source of the form and NOT the report you want to open to "SELECT * FROM " & PROGRAMSELECTION. If you want to set the record source of your report to be the above code, you would write Reports!YourReportName.RecordSource = "SELECT * FROM " & PROGRAMSELECTION
alternatively, you could write that code in the OnOpen event of the report as Me.RecordSource = "SELECT * FROM " & PROGRAMSELECTION but the PROGRAMSELECTION has to be clearly defined.
2. secondly, we SELECT values from a TABLE or QUERY. That means, PROGRAMSELECTION has to be a Table or Query name, which is always a string! That per se changes how your select statement will be written. That means it should be; Reports!YourReportName.RecordSource = "SELECT * FROM '" & PROGRAMSELECTION & "'"

one quick way to "debug" your application is to use the messagebox. You would for instance try to see, how is Access understanding Me.RecordSource?. You could simply do write MsgBox Me.RecordSource underneath the first line of code. If the SELECT statement is not referring to a table or query in your database, then you know there is a problem.

MICAH