new table but same form

  • Thread starter Thread starter civ2
  • Start date Start date
C

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
 
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.
Click to expand...

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!
Click to expand...

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.
 
Back
Top