I'm trying to set a DAO recordset to the following query:
But I get the too few parameters Error.
The form is open (and visible), the controls are named properly.
I tried wrapping the form references in the Eval() function:
But it didn't make a difference.
Help sorting this out will be greatly appreciated!
Code:
SELECT DISTINCT Temp.ID, Temp.DateUpdated FROM (SELECT DISTINCTROW B.ID,[P].[DateUpdated] FROM (tblBuyers AS B tblApartments AS P)as Temp WHERE (([Temp].[DateUpdated]) Between ([Forms]![frmDateRange]![txtFrom]) And ([Forms]![frmDateRange]![txtTo]))
The form is open (and visible), the controls are named properly.
I tried wrapping the form references in the Eval() function:
Code:
WHERE (([Temp].[DateUpdated]) Between Eval('[Forms]![frmDateRange]![txtFrom]') And Eval('[Forms]![frmDateRange]![txtTo])')
Help sorting this out will be greatly appreciated!
Last edited: