auto fill with date range

[Guest]

im making a timesheet. i would like to enter a range of of date (from-to
date) and a subform will appear with cells already filled up with the said
dates

 

[Guest]

How do you want to enter the dates?
============================================
is it using two fields in the main form that the user enter date into, then
write the sql for the sub form as:
Select * From MyTable Where MyDateField Between
forms![FormName]![FieldFromDate] And forms![FormName]![FieldToDate]

On the after update of the fields you should run me.SubformName.requery
============================================
is it using two parameters in the query that you use as the record source in
the sub form;
Select * From MyTable Where MyDateField Between [Enter Date From here:] And
[Enter Date to here:]

 

[DL]

I hope this doesnt mean you have the same data (dates) in two tbls?