Urgent help-populate a listbox from a parameterises (stored) proce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am build in a access project the backend of it is running from an SQL
server. I need to be able to bind a listbox to the query which is picking-up
a variable for the stored procedure on the fly. For some reason the List box
dosnt have a data property for "Input parameters"

Does anyone know how to do this

regards

Marcel
 
Marcel

If I understand your situation correctly, another approach would be to set
the RowSource property of the listbox to the stored procedure's result,
using code to send the parameters and set the property.
 
Jeff,


the listbox refreashes bases apon the the current user.

in other words when a I (for instance) have been added as a resource to a
record I appeard in a list box that is filtering so as to only show those
projects that I am associated to.

Part two:
to filter a listbox that is associated with a dropdown
 
Marcel

One way to get a listbox based on a selection in a combobox is to modify the
RowSource of the listbox to include a reference to the combobox. That is,
if you consider the RowSource of your listbox to be a query (a SQL
statement), then you are modifying that query to include the value selected
in the combobox as a criterion.

Is this what you mean by "filter a listbox that is associated with a
dropdown"?
 
Back
Top