W
wb
I have an access 2k ADP file that connects to sql2k on the backend.
on my unbound form I have two controls: stores and employees.
When the form loads I load all the stores into the stores list box.
When the user selects a store I want the employees list box to display all
employees assigned to the desired store.
I have a stored procedure with a single parameter (@storeId). If I set the
rowsource of the employee list box to the stored procedure there isn't a way
to define input parameters for the list control. So I get the generic
prompt for StoreId.
I want the parameter to be the value selected in the stores list control.
That way the values returned in the employee list control will be all
employees at the desired store.
any suggestions?
WB
on my unbound form I have two controls: stores and employees.
When the form loads I load all the stores into the stores list box.
When the user selects a store I want the employees list box to display all
employees assigned to the desired store.
I have a stored procedure with a single parameter (@storeId). If I set the
rowsource of the employee list box to the stored procedure there isn't a way
to define input parameters for the list control. So I get the generic
prompt for StoreId.
I want the parameter to be the value selected in the stores list control.
That way the values returned in the employee list control will be all
employees at the desired store.
any suggestions?
WB