Referencing form field for query between (1 Viewer)

mateogp

Registered User.
Local time
Yesterday, 19:00
Joined
Aug 11, 2004
Messages
43
Hey All,

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

Currently I have it setup as:
Code:
Between [Start Date] And [End Date] 
on the query.

I want to reference a form, which i figured would be like this
Code:
 Between [Forms]![frmSBReports]![txtStartDate] And [Forms]![frmSBReports]![txtEndDate]

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

Thanks!
Mateo
 

MartijnR

Registered User.
Local time
Today, 01:00
Joined
Oct 18, 2002
Messages
60
Can you use the build option (right mouse click in criteria field) to select the desired field?
 

Users who are viewing this thread

Top Bottom