Very Computer

Hi,

I had a form which had its record source set using the on
open event in an Access Form to 'select * from MyView
where Fielda = combo box on other form'.
Fine, no problems, can edit data etc.

But then I assigned a sub select:
'select * from MyView where fielda = combo AND fieldb in
(select * from tableb where fieldb = combo2).
This stopped the form from being updatable, even with the
Unique Table property set.

So I'm now using a sproc as the record source for the
form, and it expects a couple of parameters.  I can
usually pass parameters to sprocs ok, but now Im stuck.

When the form opens a couple of Input Box's appear asking
for the parameter values, not the desired effect.

Could someone let me know / point me to somewhere where I
can see how to pass a parameter to a sproc which is the
record source of an updateable form please?

Basically so a user makes a selection using combo box's in
FormA, clicks a button to load FormB which has a sproc as
its record source and has had the parameters passed from
the combos so the FormB loads correctly (without
InputBox's popping up).

Cheers!

Steve'o

It must be late in the day, eyesight not what it was.

Apologies guy's, I've spent ages looking at this but
missed the painfully obvious Form property "Input
Parameters"

So I've used the on-open event of the form to change the
Input parameter property, which passes the paramter
results to the sproc, and the form is now updateable with
a sub select in its record source!

(its odd that a having a sproc (with a sub select) as the
record source is updateable, but putting the same SQL into
the record source makes the form non-updateable).

Anyway, apologies for time wasting.

Thanks again.

Quote:>-----Original Message-----
>Hi,

>I had a form which had its record source set using the on
>open event in an Access Form to 'select * from MyView
>where Fielda = combo box on other form'.
>Fine, no problems, can edit data etc.

>But then I assigned a sub select:
>'select * from MyView where fielda = combo AND fieldb in
>(select * from tableb where fieldb = combo2).
>This stopped the form from being updatable, even with the
>Unique Table property set.

>So I'm now using a sproc as the record source for the
>form, and it expects a couple of parameters.  I can
>usually pass parameters to sprocs ok, but now Im stuck.

>When the form opens a couple of Input Box's appear asking
>for the parameter values, not the desired effect.

>Could someone let me know / point me to somewhere where I
>can see how to pass a parameter to a sproc which is the
>record source of an updateable form please?

>Basically so a user makes a selection using combo box's
in
>FormA, clicks a button to load FormB which has a sproc as
>its record source and has had the parameters passed from
>the combos so the FormB loads correctly (without
>InputBox's popping up).

>Cheers!

>Steve'o
>.