I am trying to apply criteria in a date field within my query using a between and dateadd function as per attached code. However I get an error saying that "This expression is typed incorrectly, or it is too comples to be evaluated etc....."
I understand that it is the way that I am referencing the control of the form on my query causing this but I don't know how to do it. I have used the below code which kind of works but the parameter pop up appears on my form everytime I requery. Ultimately my reference to the form will be longer as I need to reference a subform within two navigation forms which in Access 2010 requires a lot of drilling down.
Between Date() And DateAdd("d",[cmbDays],Date
Not too worried until I know the basic construct of the proper way of referencing a control on a form, as my goal is to allow the user to determine how many days ahead (1-7 days) they would like to filter the form based on their choice.
Between Date() And DateAdd("d",([forms]![frmDate]![cmbDays]),Date())