Annoying Autocorrection is breaking my form

[etejan]

Hi,

I have a form with two unbound date text boxes [StartDate] and [EndDate]. then I have a tab control with two queries that filter (or should filter) off these forms.

On the query/subform I have the date field filtered by :
Between Forms![Time Reporting tool]![StartDate] And Forms![Time Reporting tool]![EndDate]. OR thats what it SHOULD say.

Access keeps autocorrecting it to Between
[Forms]![Time Reporting tool]![StartDate] And [Forms]![Time Reporting tool]![EndDate]


A subtle yet destructive difference. I keep getting prompted to enter the date instead of the query referring to the form. When I go to SQL view and correct it there I get the same thing happening: Access breaks my query again.

How do I make it stop?

[boblarson]

Access is putting in the correct syntax. Yours is wrong. So, you need to make sure your CONTROL names on the form are

StartDate
and
EndDate

and there is no field bound to those controls named the same. If there is, change the control name to txtStartDate and txtEndDate and refer to the controls in the code.

Also, you can get the exact code for it to ensure the right names are used and syntax used, by putting your cursor in the criteria, select the BUILDER wizard button and then navigate on there to the control and double click on it. See this here:
http://www.btabdevelopment.com/ts/refer2sfrms
for how to do it (the example is for subforms/subreports but the concept is the same).