Subforms bound to paramterised Stored procedures

  • Thread starter Thread starter Martin Newman
  • Start date Start date
M

Martin Newman

I find that subforms bound to a paramterised stored procedure with the
inpputParameter property set dont work when run using the A2002 runtime,
although the same adp run in the smemachine using full Access (ie not
runtime , but either of Ac2002 or ac 2003) do work . When run under the
runtime a blank whirte space appers where the subfom should. I first
discovered this in a real application but have since experimenetd with a
stripped down very simple form/subform with a very simple table.

Anyone else seen anything like this?
 
Hello Martin:
You wrote in conference microsoft.public.access.adp.sqlserver on Fri, 11
Jun 2004 23:42:07 +0100:

MN> I find that subforms bound to a paramterised stored procedure with the
MN> inpputParameter property set dont work when run using the A2002
MN> runtime, although the same adp run in the smemachine using full Access
MN> (ie not runtime , but either of Ac2002 or ac 2003) do work . When run
MN> under the runtime a blank whirte space appers where the subfom should.
MN> I first discovered this in a real application but have since
MN> experimenetd with a stripped down very simple form/subform with a very
MN> simple table.

MN> Anyone else seen anything like this?

I tried on a trivial example, and it worked correctly. My InputParameter was
set to forms!<parent form>!Textbox1 , and textbox1 was bound. What was
yours?

Vadim
 
My input paramter propert was set to something like @spParam=130. The the
main form was unbound, and the subform bound to my SP. I think I may have
decided there is a more logical way to do this bit of the design anyway, now
but I am still curious as to why this doesnlt work as it is a constuct I may
well wish to use elsewhere.
 
Back
Top