select a product using expanding "tree" (how to)

[chang]

How can i create a from or something that will allow me
to choose what product to use in an invoice. as of rright
now i have it like the northwind database. BUT i am going
to have thousands of products, but they can in theory be
broken down into groups and subgroups etc.. . so i would
want to be able to in the invoice form click on a product
group, then it will expand to show that sub group etc..
until i finaly select the product. how would i go about
doing that. thank you

 

[Tom Wickerath]

Hi Chang,

Perhaps you can use the idea of synchronized combo boxes. Try creating the sample outlined in KB
209595 and see if that serves your needs.

How to Synchronize Two Combo Boxes on a Form
http://support.microsoft.com/?id=209595


Tom
________________________________________


How can i create a from or something that will allow me
to choose what product to use in an invoice. as of rright
now i have it like the northwind database. BUT i am going
to have thousands of products, but they can in theory be
broken down into groups and subgroups etc.. . so i would
want to be able to in the invoice form click on a product
group, then it will expand to show that sub group etc..
until i finaly select the product. how would i go about
doing that. thank you