Date filter

Sorry, that was wrong, it will prompt a second time. Instead use:

Select * from tblSchedule Where DateField Between Forms!Schedule![BeginDate]
And Forms!Schedule![EndDate];

and make sure you change the names of the table and date field to match
yours.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Arvin Meyer [MVP]" wrote in message news:...
Base your form on a query, instead of a table. The query should look like:

Select * from tblSchedule Where DateField Between Forms!Schedule![Enter
BeginDate] And Forms!Schedule![Enter EndDate];
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Chris75" u54211@uwe wrote in message news:9b00b5bee3c34@uwe...
Hello,

I've gone through various articles and posts to try to figure this
out...with
no success. I am using Access 2007.

Okay. I have a form, with the requisite unbound text boxes for Begin
Date
and End Date (BeginDate and EndDate). What I obviously want to do is
filter
my records based on those 2 controls. Here's where I am unclear. I have
read about the WHERE query and the sFilter Code. Do I do both or one or
should I just write a macro filter, which is something I have not done at
all?


My form is called Schedule.

Thanks for your help.

Chris