Combo Box In Combo Box!!!!!!!!

Hi Every 1


I am still in big problem.. And I would like help..As u guys always do thanks to all..

My problem is that:

I have A view with multible columns..Merchant ID(numbers), Merchant Name(Text), Transaction ID(numbers) And some other columns.Each Merchant have multible Transactions ID's.
In My form (Form1) I have 2 combo box (Combo0,combo2). Combo0 Have 2 columns Merchant ID and Merchant Name Sortted assending by Name. Combo2 have 2 Columns Transaction ID and Merchant ID.

What I am Trying to acompltion is when I update Combo0 with a merchant Combo2 Shows only Transaction ID's Avilable for thst merchant

by the way also i followed this URL http://office.microsoft.com/en-us/access/HA011730581033.aspx to the bone to solve the problem( which i get no errors and nothing show in combo 2!!!!!!!!!!!!!!!!!)

Please help
Regards
Iehab

re: Combo Box In Combo Box!!!!!!!!

One of our forum moderators, Rabbit, has an excellent tutorial on this subject entitled Cascading Combo/List Boxes. Why not take a look? And since your original "advice" came straight from the Micro$oft's horse's mouth (or was it the other end of the horse?) I'd scrap your first attempt and start over again!

Good Luck!

Linq ;0)>

re: Combo Box In Combo Box!!!!!!!!

Thanks A bunch work like a charm.. Thanks again..
Regards
Iehab

re: Combo Box In Combo Box!!!!!!!!

Glad Rabbit could help you!

Linq ;0)>