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