Trying to limit the selection choices in 2nd combobox based on selectiong in 1st combobox
Posted on 2014-03-25
Main form - frmCustomers
Subform (shown in datasheet view) = subfrmPets
On the subform are two comboboxes. I'm trying to limit the selections in the 2nd combobox (cboBreed), by the selection in the 1st combobox, (cboSpecies).
So in the rowsource for the 2nd combobox I have: (criteria in query designer)...
SELECT tblSpeciesBreeds.Breed, tblSpeciesBreeds.Species FROM tblSpeciesBreeds WHERE (((tblSpeciesBreeds.Species)=[Forms]![subfrmPets]![cboSpecies])) ORDER BY tblSpeciesBreeds.Breed;
But nothing is showing up.
What am I doing wrong?