Referencing form field for query between

[mateogp]

Hey All,

I have a question regarding referencing a form using dates between.

Currently I have it setup as:

Between [Start Date] And [End Date] 
on the query.

I want to reference a form, which i figured would be like this

 Between [Forms]![frmSBReports]![txtStartDate] And [Forms]![frmSBReports]![txtEndDate]

But this doesnt work! What did I do wrong here? Any help as always is greatly appreciated!

Thanks!
Mateo

 

[MartijnR]

Can you use the build option (right mouse click in criteria field) to select the desired field?