RESOLVED - Create a Record Search Combobox

[BorisMartian]

I have a form connected to an Access DB. I use the DataAdapter (DAsqlClients) and DataSet (DSClients) method to populate the form with data. Basically the form is a simple list of clients names (CompanyName) each with a unique ID (CoID)

Now what i want to do is create a combobox which has all the Company names in it and when i select a company from that list it will go to straight to that record so i can do something with it.

Can somebody give me some help in trying to achieve?

Thanks.

[theonewhowas]

Boris:

I'm not sure this is what you are looking for but u can give it a try.

Create a new combo box

in the Datasource field, select the dataset (but not the dataset with the .(tablename)

in the Display member field and the value member field, select the table/column you would like to select from

if this is not what you are looking for, I apologize. I am rather new to this myself.

~~The One Who Was~~

Originally posted by BorisMartian
I have a form connected to an Access DB. I use the DataAdapter (DAsqlClients) and DataSet (DSClients) method to populate the form with data. Basically the form is a simple list of clients names (CompanyName) each with a unique ID (CoID)

Now what i want to do is create a combobox which has all the Company names in it and when i select a company from that list it will go to straight to that record so i can do something with it.

Can somebody give me some help in trying to achieve?

Thanks.

[BorisMartian]

Your a legend! I've been mucking around with this for ages and now it seems to work just how i want it.

Thanks for that.