selecting data from a combobox to get more data in a listbox

[purejoker]

im new to this so hello every1!!!

umm.. i have a form with a combo box which is linked to a table which gives me customer id numbers. and i have a listbox which i want the names and addresses to appear when i select a cusotmer id number from the combo box

so on the list box i put
" SELECT CustName FROM Customers WHERE CustID=$combo43; " in row source; if i change $combo43 to 0 the name appear but that is fixed and i want it 2 change when i select a cusomer id number from the combo box

can some1 plzz help me, its 4 my college project!

thanxs in advance!

purejoker!

 

[pablofonto]

Hey Purejoker,

When you create your combo box if you're using the wizard, there is an option where you can have your combo box find a record on the form based on the value you select in your combo box. This will cause that every time you select something different from your combo box the rest of the text boxes will update with the information pertaining to what you select. I hope this helps!

PF