Im attempting to have a user select the table, fields and criteria to create a SQL statement query and run it immediately, from a form in MsAccess.
Ive tried to build and store the SQL statement in a string, set it as a new querydef,open an existing query and set its sql to the string. I have been unable to get this to work however. I either get a "obj var/ with block var not set" error or invalid SQL statement . However the syntax of the statement is correct according to tutorials ive followed. Can any1 offer sum help?