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?