I am using this Change SQL property of saved query (DAO) function by Mr. dhookom (faq701-7433) on my form.
However the new strSQL won't load until after I reopen the form the second time around.
Any idea why it isn't loading the first time? Or is there a work around on this?
I am using Access 2013.
Thanks in advance.
However the new strSQL won't load until after I reopen the form the second time around.
Any idea why it isn't loading the first time? Or is there a work around on this?
I am using Access 2013.
Thanks in advance.