I am trying to create a form that functions as a dynamic query based on information provided by the user in the form consisting of a list box, some combo boxes and text boxes.
I found this link that displays a how-to example with the VBA code for the Northwind sample database: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q117544
I enter in the code, and even cut and paste it. My first problem I encounter before I can even test to see if and how this works is the very last line, where VBA keeps giving me an "complile error message - expected end of statement":
DoCmd OpenQuery "Dynamic_Query"
I found this link that displays a how-to example with the VBA code for the Northwind sample database: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q117544
I enter in the code, and even cut and paste it. My first problem I encounter before I can even test to see if and how this works is the very last line, where VBA keeps giving me an "complile error message - expected end of statement":
DoCmd OpenQuery "Dynamic_Query"
