procedures views and subforms

  • Thread starter Thread starter Educo Gent
  • Start date Start date
E

Educo Gent

I use microsoft access 2002 and sqlserver 2000.

Is it not possible to use a stored procedure as source of a subform in a
form (both are linked by a field)? Problem is: the records shown in the
subform are not only those who are linked with the record in the form, but
all records are shown.

If I use a view as source for the subform, the problems are solved.

Thanks for help.
 
Use parameters in the stored procedure to filter the records to the parent
form and then set the imput parameters in the sub form to reference the
parent form field that corresponds to the parameter.

In the subform input parameters you would do something like:

@InventoryID INT = Forms("NewProducts")("IMInventoryID")

Where the form you are referring to is te parent form.

HTH,
Jim
 
thanks for help

J. Clay said:
Use parameters in the stored procedure to filter the records to the parent
form and then set the imput parameters in the sub form to reference the
parent form field that corresponds to the parameter.

In the subform input parameters you would do something like:

@InventoryID INT = Forms("NewProducts")("IMInventoryID")

Where the form you are referring to is te parent form.

HTH,
Jim
Click to expand...
 
Educo Gent said:
I use microsoft access 2002 and sqlserver 2000.

Is it not possible to use a stored procedure as source of a subform in a
form (both are linked by a field)? Problem is: the records shown in the
subform are not only those who are linked with the record in the form, but
all records are shown.

If I use a view as source for the subform, the problems are solved.

Thanks for help.
Click to expand...
 
Back
Top