access forms

[Guest]

Hi! In access I have a form that has been already created that was used for
2004 information. I would like to create the same form for 2005 but I do not
know how to do that without creating a new form from scratch. Any help would
be great. Thank you.

 

[Alex White MCDBA MCSE]

Hi Lindsay,

You should be able to copy it in the database window in access in list view
right mouse click on it and copy then right mouse click on any white space
area in the database window and paste, call it something new, but how is
your data structured?

may have to do something with your queries/tables? don't know, if you need
more help post here.

 

[Guest]

Thanks, I got the form to copy but the 2004 information still came with it.
I'm not sure how the data is structured either. I'll keep working on it!

 

[Mark M]

If all you want to do is not show anything from the year 2004, try altering
the form's underlying query and set the criteria for the date to be
something like Year([OrderDate])>2004.