I have a Form with a ComboBox that uses a Select Query to select data to be used to create a new record in a table[REGISTRATION]. The query uses the same table [REGISTRATION] that I am creating the new record in. Once I select an option in the ComboBox and save the record containing it to the table [REGISTRATION], I don't want it to be available again in the ComboBox.
If I close and reopen the Form the new record in the table [REGISTRATION] no longer displays in the ComboBox which is what I want.
How do I get this to happen without closing and reopening the Form?