This problem has been plauging me for the last few months. I have an Access ADP application connecting to a SQL Server 2005 database. I have a continous form. My goal is when I open the form, I want to build my own stored procedure call, with parameters that I determine and provide in VBA code.
I'm building a SQL call and then using either Me.RecordSource or (executing the call myself) and using Me.Recordset to update the form. The problem is that Access is still prompting me to enter parameters, even once I've made the call and updated the form. It seems to want to automatically populate that InputParameters field for me. Also, oddly, it prompts me for the same parameter multiple times.
Something odd is going on. I ran in debug mode and saw that it was prompting for parameters even after the Me.Recordset command. Does anyone have a solution for this? Oh - another oddity - everything seems to work fine when I have only one parameter, but as soon as I have 2 or more, this problem starts.
Thanks,
H
I'm building a SQL call and then using either Me.RecordSource or (executing the call myself) and using Me.Recordset to update the form. The problem is that Access is still prompting me to enter parameters, even once I've made the call and updated the form. It seems to want to automatically populate that InputParameters field for me. Also, oddly, it prompts me for the same parameter multiple times.
Something odd is going on. I ran in debug mode and saw that it was prompting for parameters even after the Me.Recordset command. Does anyone have a solution for this? Oh - another oddity - everything seems to work fine when I have only one parameter, but as soon as I have 2 or more, this problem starts.
Thanks,
H
