Thread: populate list with unique field value on repeated field value
View Single Post
 
Old 04-03-2018, 06:13 PM
sukusnairss sukusnairss is offline Windows XP Office 2007
Novice
  
Join Date: Mar 2018
Posts: 2
sukusnairss is on a distinguished road
Default populate list with unique field value on repeated field value
Dear All
I have following database on excel

PINCODE TALUK DISTRICT STATE/UNION TERRITORY
744102 PORT BLAIR SOUTH ANDAMAN ANDAMAN & NICOBAR ISLANDS
744101 PORT BLAIR SOUTH ANDAMAN ANDAMAN & NICOBAR ISLANDS
744202 DIGLIPUR NORTH &MIDDLE ANDAMAN ANDAMAN & NICOBAR ISLANDS
744202 DIGLIPUR NORTH & MIDDLE ANDAMAN ANDAMAN & NICOBAR ISLANDS
744202 DIGLIPUR NORTH & MIDDLE ANDAMAN ANDAMAN & NICOBAR ISLANDS

I want to create a drop down list in vb form where state should show only unique value, then the next box linked to it to show only unique DISTRICT, again linked to show unique TALUK
Reply With Quote