Hey all, I've got to write a project that involves populating combo box's through access, and also saving the data to an array and being able to sort and display in a list box.

The project consists of two forms. The customer form and the order form, and uses three tables in a database.

The first table I want to save the customer infomation too. For Example, take the data from txtForname.text and add it to the Forname field within the table.

and the second table I want to add data from fields in the table and show it within the combo box on my order form. For Example, If i add "blue" into the field called "colour" within the table and then "blue" will be added to cboBlue.text within my vbproject

if someone could explain how I do this or link me to a good explanation on the net i'd be very greatfull, after hours of google I still havent found anything I can work off.

Cheers.