Use stored procedure as record source on subform
Posted on 2006-06-01
I must be an idiot today. I'm trying to create a subform in access. The wizard asks me, "What data would you like to use for your subform or subreport?" It gives me the options of 'Existing Table and Views' or 'Existing Forms'. Stored procedures is not an option. If I select 'Table and View' stored procedures are not listed. If I cancel the wizard and type the name of my stored procedure into the subform properties Record Source it says, "The form name 'myProcedure' is misspelled or refers to a form that doesn't exist".
I've only ever created one subform in Access about six months ago and it specifies a stored procedure as the record source. How did I get the s.p. in that subform? I have amnesia.