add data for the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a form with these 4 peoples names
Monthly activity
Name Approvals Post Closings Final
Documents
Dan Smith 10 15
Joe Green 11 12
Frank Thomas
Daryl Green

the users enter the data as they get it through out the month, i want, when
they open up the form with the names that it keeps all the data in the fields
on the form until the next month. so lets say im entering numbers for this
month i should see the above numbers, then if i go to the form the next month
the data is back to 0 and i cant start over entering. is there a way to do
this?
 
Add a DateTime field to your table with default as Format(Date(),"yyyymm")
and in your query that is record source for the form add the field.
Use this as criteria --
Format(Date(),"yyyymm")

You will only see the current month's data entries.
 
Back
Top