Hi all, I hope you can help me.
I want to use the selected row in a list box , which has 3 fields in it. CustID, CustADD and CustName.
that will then populate a second list box with invoice details where the custid from a invoice table is = to the custID in the first list box.
So that I have a number of invoice details for the CustID listed in the list box 2
once this is found and then select a row for this listbox to product report showing the invoice details..
The aim is to allow staff to look at a preview list of invoice details of any customer and then select the correct invoice and produce a report showing the full invoice details
Miked666
I want to use the selected row in a list box , which has 3 fields in it. CustID, CustADD and CustName.
that will then populate a second list box with invoice details where the custid from a invoice table is = to the custID in the first list box.
So that I have a number of invoice details for the CustID listed in the list box 2
once this is found and then select a row for this listbox to product report showing the invoice details..
The aim is to allow staff to look at a preview list of invoice details of any customer and then select the correct invoice and produce a report showing the full invoice details
Miked666