Problems with the criteria fild

[Guest]

I made my own form (Fecha) where there are a beginig date and an end date in
textbox1 and textbox2 consecutivitly, I put in my querys criteria field the
following code: Between [Forms]![Fechas]![Text1] And [Forms]![Fechas]![Text2]
but when I run the query appears tow forms, the first one with the label
[Forms]![Fechas]![Text1] and the ok, cancel buttons; the second one with the
[Forms]![Fechas]![Text2] label and ok, cancel buttons.
How could I run my form and give the values to my query????

 

[t t via AccessMonster.com]

you are typing wrong criteria as below

Between [Forms]![Fechas]![Text1] And [Forms]![Fechas]![Text2]


correct one must be

Between Forms![Fechas]![Text1] And Forms![Fechas]![Text2]

 

[Guest]

I put what you suggested but computer changes automatically to the Between
[Forms]![Fechas]![Text1] And [Forms]![Fechas]![Text2] type.

 

[Jeff Boyce]

If you have a form, and you have a query that looks for values on that form,
the two most common reasons why this fails are
1) there's a spelling error in the query criterion, and
2) the form is not open when the query is run.

Good luck

Jeff Boyce
<Access MVP>