I have used the following in the criteria of the field I'm checking
Between [Forms]![AddDdScheduleFrm]![FirstDateFld] And [Forms]![AddDdScheduleFrm]![EndDateFld]
I'm testing this away from the form so it prompts me for the date values
I don't get any results. Am I using the right syntax
I know that there are records on the file that meet the criteria
Thanks for reading this
Between [Forms]![AddDdScheduleFrm]![FirstDateFld] And [Forms]![AddDdScheduleFrm]![EndDateFld]
I'm testing this away from the form so it prompts me for the date values
I don't get any results. Am I using the right syntax
I know that there are records on the file that meet the criteria
Thanks for reading this