Combo Box filtered by Combo Box

[OptimisticYid]

I have just installed a new invoicing system and would like to add in a development. At present when you go to view an old order you can use one of two combo boxes to find a record, either by order ID or by customer name.

My ideal would be to set up one combo box that details all the fields on the order ie. orderID, orderdate, postcode, name, etc etc and this selection filters the results in the second combo to list the orders by the chosen field giving a much wider search capacity.

Any suggestions on where I should start?

Thanks in advance for any help you can offer

 

[KenHigg]

I think this is referred to as cascading comb boxes. Do a search on the forum and you should get good results.

 

[twoplustwo]

Hey,

This is one of my fave links: http://www.fontstuff.com/access/acctut10.htm