Ben - or anyone! Comboboxes and rowsourcing
Posted by Richard on July 12, 2001 4:44 AM
Hi there,
i am extremely unadvanced, this is my first crack at creating a form or using vb at all.
i so far have 3 comboboxes
the first is a list of customers, the second and third appear when a customer in the first box.
the second box should show what that customer has purchased
i have used indirect in the rowsource, how can i get this to change relative to what has been selected in the first combobox, i would use vlookup in a spreadsheet but do not know how to do this when using vb editor.
Thanks
Richard