why this is not working????

[Guest]

Good morning, I'm tryng to put a customized form in one of my queries like
this: beetwen forms![dates]![begdate] and forms![dates]![enddate], but when
inserted it in the criteria fild automatically changes to between
[forms]![dates]![begdate] and [forms]![dates]![enddate]; so when I run the
query appears two forms, one with the label [forms]![dates]![begdate] and
the second one with the label [forms]![dates]![enddate], and I just whant to
appears my form.
How to accomplish what I want???????
TIA

 

[Rick Brandt]

Good morning, I'm tryng to put a customized form in one of my queries
like this: beetwen forms![dates]![begdate] and
forms![dates]![enddate], but when inserted it in the criteria fild
automatically changes to between [forms]![dates]![begdate] and
[forms]![dates]![enddate]; so when I run the query appears two forms,
one with the label [forms]![dates]![begdate] and the second one with
the label [forms]![dates]![enddate], and I just whant to appears my
form.
How to accomplish what I want???????
TIA

A form reference will not cause a form to open when the query is run. You
would normally open the form first, make your entries, and then press a
button to run the query or the form/report that uses the query.