Query not showing in Navigation Pane

[mp3909]

I create 2 temporary queries using access vba via the CurrentDb.CreateQueryDef() method.


The first query I can see visible in the navigation pane but the second query I do not see until I physically click on one of the existing queries in the navigation pane.

Is there a way to refresh the navigation pane via vba so that it shows all objects?

[Micron]

try Application.RefreshDatabaseWindow
or
CurrentDb.QueryDefs.Refresh (I might have that syntax wrong)
FWIW, a temporary query is a specific thing - a query you create that only exists in machine memory and dies when the procedure is over. A query you create may be temporary to your way of thinking, but I wouldn't call it that.