How do I set my stored procedure as the record source to a form?

Where is my stored procedure listed so I can select it as the source?

Thanks,

1DMF.

ok, found you need to create a passthrough query with an embeded connection string.

In the query you write EXEC sp_stored_procedure

And then it will grind your application to a halt, even just trying to navigate around in 'develop' mode will have your db locking up, egg timing and basically stopping you from being able to work.

I don't understand, i was told SP's were fast and much better, why has it killed my application?