If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
I have a form and a textbox on it.
The control source of the textbox I want to be based on a SELECT statement from a specific table independently from the Recordsource of the form.
So, I've tried something like "=(SELECT Month FROM tblMonth WHERE ID=1)" into the textbox's Controlsource but I always get a #Name? error.
Any help will be apreciated!
Please have look DLookup Function in the VBA help file
Sample code given in the help file is below
=DLookup("[ProductName]", "Products", "[ProductID] =" _ & Forms![Order Details]!ProductID)hope this helps