How can I sort information in a form by the year?

I am working with a form created years ago that you enter information into to
book different tours. What I want to know to do is to be able to scroll
through the form and only have the current years information, but I also want
to be able to have the past information saved somewhere so that I can still
go back to it if need be. Can I make multiple files within the form or can I
save it somehow and clear the form each year?

Just change the recordsource of your form with a different
filter for the year.

Private Sub Form_Load()
me.recordsource="Select * From MyTable Where
TableYear= " & YearParm
end sub


-----Original Message-----
I am working with a form created years ago that you enter
information into to
book different tours. What I want to know to do is to be
able to scroll
through the form and only have the current years
information, but I also want
to be able to have the past information saved somewhere
so that I can still
go back to it if need be. Can I make multiple files
within the form or can I
save it somehow and clear the form each year?
.

Can anybody put the last message into simpler terms for me or suggest a
different way that I might be able to understand. I'm not very
electronically inclined. To me, it looks like entering code and i don't know
where to do that in Access. Thanks again


"Ofer" wrote:

Just change the recordsource of your form with a different
filter for the year.

Private Sub Form_Load()
me.recordsource="Select * From MyTable Where
TableYear= " & YearParm
end sub


-----Original Message-----
I am working with a form created years ago that you enter
information into to
book different tours. What I want to know to do is to be
able to scroll
through the form and only have the current years
information, but I also want
to be able to have the past information saved somewhere
so that I can still
go back to it if need be. Can I make multiple files
within the form or can I
save it somehow and clear the form each year?
.