I have an append query and I want to update a table in my current database with a table from an external database (Reporter_Update). The external databases' directory path is stored in a text box (Text109) on one of the current databases' forms (MainFormFilter).
How do you reference a form in SQL? (the bit in green below)
How do you concatenate two strings together in SQL (red below)
How do you write a string in SQL? (blue below)
INSERT INTO Dwelling
IN Forms!MainFormFilters!Text109 &" "& "\Reporter_Update.accdb"
Hopefully you can clearly see my confusion. I'm not use to SQL and get muddled between it and VBA.