I'm using one database table in connection with two DataCombo Boxes and I'm having 2 major
problems, using the selected item of one combo list to determine what list will be used in the second
combo box and using both comboboxes to update the current record in the table.
I filled the first DataCombo Box with an ADO query using the SQL statement:
Select Distinct Breed from Table1
to get a list of all the breeds in my table with no repeated breed names. This works, so the rest
composes the two major problems.
1. I'm using 2 data controls, (Adodc1) to fill the list for the first DataCombo Box (cboBreed) and
(Adodc2) to navigate through the records shown in the textboxes on my form. I probably need a third
data control to fill the list for the second DataCombo Box (cboVariety). I want it so that when I click on
a breed in cboBreed a list of Varieties for just that breed shows up in cboVariety. The list of breeds and
varieties are not predefined, they are defined by the user in the textbox portion of the DataCombobox
because the types of breeds and varieties can change from year to year.
2. I need the item that the user selects from each list to be used to update the current record in
Adodc2.
Can anyon help me with this or show me some examples as how I might get this idea to work????
