help with list box

[accesslearner]

Thanks to this forum i have been able to create 3 combo boxes that work to filter some values in my form.

I have 3 -4 combo boxes like cboname,cbostate,cbocompany etc.
My next attempt is to have a list box which has row source bound to a query.

I have some variables

Firstname
State
CompanyName
Country
JobTitle

What is want to do is when i click on Firstname the cboname should be displayed and all other controls hidden and so on.

The idea was just to have a list box for the user to filter and have combo boxes and text boxes hidden and when the user clicks on the specific list items that control should display and the user can filter the data.

Is there a more dynamic way to do this.

any help will be appreciated.

 

[Guus2005]

You can program the onChange event of the combobox from which you select Firstname, state, etc.
In the onChange event of the combobox you change the query of the listbox to show the selection only and requery the combobox.

HTH