I am using code like this to query my DB from a form, this form is a dynamic query generator the code i am using to use SELECT statement on the database is
SqlString = "SELECT * FROM tblInput WHERE(location='Aberdeen')"
CurrentDb.QueryDefs("Query1"
.SQL = SqlString
DoCmd.OpenQuery "Query1"
This is a simplified version of the code but i still get the same error - it is - Run Time Error '3265' - Item Not Found in This Collection.
Now this is an extremely simple query and i cant even get that to work!!! Help!
SqlString = "SELECT * FROM tblInput WHERE(location='Aberdeen')"
CurrentDb.QueryDefs("Query1"
DoCmd.OpenQuery "Query1"
This is a simplified version of the code but i still get the same error - it is - Run Time Error '3265' - Item Not Found in This Collection.
Now this is an extremely simple query and i cant even get that to work!!! Help!