I have a form with a text box where the textbox value should be populated with the maximum flowrate from a table. I wrote the following code:
txtTest.ControlSource = "SELECT DISTINCT MAX(FlowData_BoweryBay.[Flowrate]) FROM FlowData_BoweryBay;"
When I open the form, the textbox contains #Name?
What am I doing wrong?
Jim
txtTest.ControlSource = "SELECT DISTINCT MAX(FlowData_BoweryBay.[Flowrate]) FROM FlowData_BoweryBay;"
When I open the form, the textbox contains #Name?
What am I doing wrong?
Jim