hi all,

I am trying to use two drop down lists in an attempt to populate an order form -

the drop down boxes are called

SUPPLIER - this contains all the names of the suppliers I use

STOCK DESIGNATION - this contains two phrases CONSIGNMENT STOCK and BOUGHT STOCK

I want to be able to select a supplier and a stock designation and then for all matching items in the data sheet to auto fill an order form -

Example

in supplier i select PLUMB CENTER and in stock designation i select CONSIGNMENT

the fields in the order form are headed ITEM DESCRIPTION, STOCK CODE and RE-ORDER QTY - i would need all the instances where PLUMB CENTER and correspondes with CONSIGNMENT STOCK to then fill the 25 or so lines of the order form automatically

please help - desperate to get this working