RESOLVED - Create a Record Search Combobox
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.
Re: Create a Record Search Combobox
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~~
Quote:
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.