I am using VBA to create a query, but the issue I have is that when this is completed thet query is opened on screen. How can I create teh query, but not have the query be opened, but just reside in memory to be called later?
Code:Dim empName As String, strsql As String, qdf As QueryDef empName = Me.combobox1.Column(1) strsql = "Select * FROM helperDB where empName = " & empName & ";" Set qdf = CurrentDb.CreateQueryDef("NewQuery", strsql) DoCmd.OpenQuery qdf.Name