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?
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…