Form Filter (1 Viewer)

[rohanmalhotra83]

Hi all

I have a form which has 3 comboboxes. What i am looking to do is to filter the combobox based on other. That is, when the user select an option from first combobox, the options in below combobox filters and accordingly and when an option is selected in second combobox, the options in third combobox is filtered accordingly.

I know its bit complicated, however, if anyone could help it would be great.

Thanks in advance.
Rohan

 

[Yarp]

I figured this one out myself recently, so there may be a better way, but this is how I did it.

Basically you need to enter a valid query into the 'Row Source' on the combobox2 properties. I assume you have already done this combobox1. You can either create a query and call that, or just plug the SQL into the 'Row Source'.

Next I created some VBA for the 'After Update' Event on combobox1. This VBA is (for example)

me.combobox2.requery

.

Each time you change the selection in combobox1, your options should change in combobox2. Without knowing your level of knowledge, it is harder to go into further details. Just post back if you have any questions.

 

[vbaInet]

It's called cascading combo boxes. You will find a tutorial from pbaldy here:

http://baldyweb.com/CascadingCombo.htm

 

[rohanmalhotra83]

Thanks for this... it was really helpful. However, could you please tell me if i want add this data to a table, how that can be done?

 

[vbaInet]

You use a form and put it in the After Update event of the combo box. Have a look at the tutorial again.