new table but same form

[civ2]

i will appreciate help like you have no idea!

i've created a table for some activity in 2003, and a form that deal
with data from it. now i want to create a similar table for 2004, and
need to have the same form for it. i can make a copy of a 2003 form
but my question is, * how do i re-refer a copy of the old form to tak
data from the new table?* or do i have to make the form from scratc
again? thank you so very much

 

[John Vinson]

i will appreciate help like you have no idea!

i've created a table for some activity in 2003, and a form that deals
with data from it. now i want to create a similar table for 2004, and i
need to have the same form for it.

Ummm... BAD design. Sorry, but storing data (a date) in a tablename is
really unwise. If you have a date/time field in the table, you can
simply create a Query selecting 2003 data or 2004 data!

i can make a copy of a 2003 form,
but my question is, * how do i re-refer a copy of the old form to take
data from the new table?* or do i have to make the form from scratch
again? thank you so very much!

If you really want to do this anyway, simply open the Form in design
view; find its RecordSource property (first on the Data tab); and
change it to the name of your new table.