Combo Box

[mithani]

Hello,

I have two combo boxes, First combo I will select invoice number and when I click on my second combo, should bring all matching with same invoice number. I am trying the this sQL statement but not working.

SELECT QueryInvoiceChild.description FROM QueryInvoiceChild WHERE QueryInvoiceChild.InvoiceNo=form!combo19 ORDER BY [description];

Your help apprecaited.

mithani

 

[pbaldy]

http://www.mvps.org/access/forms/frm0031.htm