duplicate form

  • Thread starter Thread starter Captain Jim
  • Start date Start date
C

Captain Jim

I have a great form for my 2004 info. can I somehow duplicate the old form
but use new 2005 tables? In other words can I change the tables that a form
is based on?

Thanks,
Jim
 
While in design-view, double-click the black square in the upper left corner
of the window. This will open the form's properties box. Look at the data
tab and adjust the record source.

Rick B
 
Just FYI, personally, I would not build a separate form for each year (nor
would I have the records in different tables if it were me).

You could add filters to pull records for a specific timefarme and tie them
to radio buttons, or combo boxes.

You could also create a form for "current year" and one for "previous year"
so it would be more dynamic. (again, this would only work easily if all the
records lived in one table)

Rick B
 
Back
Top