I am running a report with the control source as a view. I want to enter a prompted date but when I set the date field as =? I get an ADO error. I did try using the view's code as a query but it is based on 3 other views and still does not work.

I had written a stored procedure using on our server but I can't run this from any other computer on the network. And I have set all the permissions to access it.

Any ideas?
Help would be greatly appreciated!


p.s. when I try to create a stored procedure on my pc it says:
Microsoft Access can't find the object 'Microsoft Access can't find the object 'StoredProcedure1.'.'

What is that about? Kinda weird!