Check Previous Orders

[Lana21]

Hey,

I have an orders form, which makes the orders, but I would also like to be able to search back through old orders to append them in the same form.

Currently I have frmOrders, which has a combo for the customersID (which then adds their details to fields). In this form I also have frmOrderDetails as a subform, which is used to input the products.

Basically I would like to add a combo box which displays the order no. and the customer who's order it is. By clicking it all the order details will appear in the form. I've tried the way I thought, which does bring these details up in the combo box but it doesn't change the rest of the form when I click it!

Is this possible, and what's the best way? Thanks.

 

[llkhoutx]

Picking an order out of a combo box list merely provides a value for filtering the form recordset. You have to use that value to filter the records (with Me.filt="Filter criteria using the combobox value" ; and me.filterpon=true).

anouther was is to build a sql string of your form's recordsource, adding the critia with the combobox vale; and the, requerying the form.