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).