Hi all,
I have a very simple update stored procedure called "pricesupdate"
I need this to run on the open event on one of my forms.
To do this I use VBA. My question is, how can I run and update stored procedure from VBA?
I would have thought it be as simple as:
"DoCmd.OpenStoredProcedure....etc" but no, tried that and get error saying "Microsoft Access Cannot Find...." so whats the answer guys? This one is annoying me because surely it should be so simple....or am i wrong?
Thanks in advance,
Ash.

So this is a stored procedure on a SQL Server? Or is this some other routine on the Access database?

You can write such an Update function in either a query or in code that you can execute on the form's On Load event. I can help with that, too.

mmcdonal