I am trying to set up an append query to append to an external Access database table where the path to the external database is user defined from a form. I have set my query IN clause to '[Forms]![FormName]![TextBox].mdb'. Where TextBox is user input of [C:\My Documents\DataBase].
I have two proplems when I run the query:
When I run the query, I get an error message that it cannot find file "C:\My Documents\[Forms]![FormName]![TextBox].mdb". Access has somehow combined and truncated the user defined path and the [Form] and [FormName].
The other problem is if I clear the [TextBox] so that the Text Box is blank, and run the query, I get exactly the same error message.
I've run the query when I hard code the path into the IN clause and it works fine.
Any suggestions?
I have two proplems when I run the query:
When I run the query, I get an error message that it cannot find file "C:\My Documents\[Forms]![FormName]![TextBox].mdb". Access has somehow combined and truncated the user defined path and the [Form] and [FormName].
The other problem is if I clear the [TextBox] so that the Text Box is blank, and run the query, I get exactly the same error message.
I've run the query when I hard code the path into the IN clause and it works fine.
Any suggestions?