Thank you, Its worked like a charm.
--------------------
(Ms-Exl-Learner)
--------------------
"Douglas J. Steele" wrote:
> Use Forms![NameOfForm]![From_Date] and Forms![NameOfForm]![To_Date] as the
> parameters in your query.
>
> --
> Doug Steele, Microsoft Access MVP
> [URL="http://www.AccessMVP.com/DJSteele"]http://www.AccessMVP.com/DJSteele[/URL]
> (no e-mails, please!)
>
> "Ms-Exl-Learner" wrote in message
>
> >I have created a Select query for retrieving some particular Date Records
> > from a table using the BETWEEN expression in query criteria bymentioning
> > the
> > From Date and To Date and it's working fine.
> >
> > Each time I don't want to open the query and enter the From Date and To
> > Date, so I want to create TWO Unbound text box in Forms for entering the
> > From
> > Date and To Date and nearby the text box I am having a command button to
> > run
> > the query.
> >
> > Now I want to know how I can connect the Two Unbound Text Boxes that is
> > From
> > Date and TO_DATE which is created in Forms in the Select Query (BETWEEN).
> > I
> > want the select query to pick the From date and To Date from the form text
> > boxes and run the query.
> >
> > Hope someone will give your valuable suggestion.
> >
> > --------------------
> > (Ms-Exl-Learner)
> > --------------------
>
>
> .
> >> Stay informed about: Connecting Text Box in Query Criteria