Ok, everyone said don't try to alter a view from an SP. The problem was getting a SP to be the RecordSource for a report in the Access front end. I put the proc in as the RecordSource and hard coded a parameter and the report ran. Then I make a form where the user entered the parameter in a text box and clicked a command button. The code behind the command button reset the focus to the text box (you need that to get the text copied to a variable in the next step) and then opened the report. The reports open event assigned the text boxes text to a variable and then set the RecordSource to the proc with the variable as the parameter. It worked
Someone suggested that the parameter could be put in the report’s Input Parameters, but that did not work.
Someone suggested that the parameter could be put in the report’s Input Parameters, but that did not work.
