Display data in form from worksheet using Filter
 

Hi,

I need to pull the data from the worksheet to the forms using Autofilter or filter. I am also new to the filter coding.

I have four columns in my worksheet ie: ID, IDName, Parent ID, ParentIDName. I need to pull the information from the worksheet in the two combo boxes. First combo box should have Parent IDs and when i click on Parent ID, the second combo box should display the IDs belongs to Parent ID.

I am thinking it would be very easy to solve this using filters.

Can somebody help to provide some assistance using AutoFilter or filter to do this task?

Thanks

Display data in form from worksheet using Filter
 

You migh look at
Debra Dalgleish's site on how to do this:

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

--
Regards,
Tom Ogilvy

"VJ" wrote in message
...
Hi,

I need to pull the data from the worksheet to the forms using Autofilter
or filter. I am also new to the filter coding.

I have four columns in my worksheet ie: ID, IDName, Parent ID,
ParentIDName. I need to pull the information from the worksheet in the two
combo boxes. First combo box should have Parent IDs and when i click on
Parent ID, the second combo box should display the IDs belongs to Parent ID.

I am thinking it would be very easy to solve this using filters.

Can somebody help to provide some assistance using AutoFilter or filter to
do this task?

Thanks