Allowing parameterised queries after listbox select update event

[Guest]

I am trying to use listboxes/ combo boxes to allow a drill down structure to
select data from an underlying ACCESS DB.
I have some forms with a combobox which reads values from a SELECT query. I
would like subordinate queries to accept paramterised values retuned by the
selected value in my listbox to accept the selected value as a parameter and
return values based on this.
Specifically I have a list of clients, each of whom have multiple addresses
with multiple contact details at each site. I would like to select a Client,
and use the ClientID value returned by my SELECT query to be used inallowing
me to populate a listbox based on potential sites, and use subsequently
selected SiteID values to popluate a SELECT query populated listbox to show
me potential contacts.
I have an idea how to do this in VB.NET, and figure that the process would
involve using listbox.selectedIndexChanged events to fire a Macro that would
run a function/procedure which would accept a parameter to run the
appropriate query, but am at aloss as to how to implement this.

Is there coding/ example which I could review to facilitate this.

Assistance greatfully accepted.

Andrew Allan

 

[Brendan Reynolds]

Do you mean that you want to filter one Access combo box or list box based
on the value of another? If so, see the example at the following URL ...

http://www.mvps.org/access/forms/frm0028.htm