If the listbox is based on the query you're showing, after you copy the value to the unbound textbox, delete the row from the underlying table at some point, then requery the listbox. I'm not certain as to what's what in your design, but the sql statement might look something like
Code:
DELETE FROM tblCommonNames.CommonName WHERE SpeciesID = [forms]![MempSpeciesfrm].ListBoxName.ItemsSelected
Of course, you could expand on this and assign values to variables, trap for possible errors (such as the error you'd get if the item has been deselected) and use the db.Execute method or just DoCmd.RunSql
Last edited by Micron; 10-11-2017 at 12:57 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.