Application.RefreshDatabaseWindow (Access)

The RefreshDatabaseWindow method updates the Database window after a database object has been created, deleted, or renamed.

You can use the RefreshDatabaseWindow method to immediately reflect changes to objects in Microsoft Access in the Database window. For example, if you add a new form from Visual Basic and save it, you can use the RefreshDatabaseWindow method to display the name of the new form on the Forms tab of the Database window immediately after it has been saved.

Sub CreateFormAndRefresh() 
 Dim frm As Form 
 
 Set frm = CreateForm 
 DoCmd.Save , "NewForm" 
 RefreshDatabaseWindow 
End Sub