Susan Harkins
ssharkins at gmail.com
Wed Sep 10 10:45:57 CDT 2014
Setup -- I'm using a combo box to offer current species so the user can just select one instead of re-entering. If the species isn't available yet, there's a command button the user can click to enter the new species. The combo box is populated by a species lookup table. Using the combo box's Click event, I tried to requery the list as follows: Private Sub SpeciesIDFK_Click() 'Repopulate species combo after adding new species. Me.Requery End Sub The popup form is entering the new species -- I've checked the underlying table and it's there. But, when I return to the main form and click the comb box's dropdown arrow to review the list again, the new species is not in the list. I dropped in a Debug.Print after the Requery method to at least let me know the event is firing and apparently it isn't. I went looking for a dropdown event and while there's lots about what it is, there is not a dropdown event in the Events dropdown in the VBE for the combo box control in question. Any help? Susan H.