Linking a replica new form to a replica new table?

[RSHH]

I have created a new form from and old one as I wanted the same format, now I need to link that form to a different table.
I have cretaed the new table by copying only the structure of the old table that is linked to the old form, so I got the new table with the structure I wanted and the new form, Now I just need to link those new ones.

Any advise on how to do it will be apreciated

 

[mrf1xa]

It should be as simple as this:

Go to design view of your new form
Go to the form properties box.
Find the Record Source row and change it from your old table to the new one.

HTH Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[RSHH]

Thank mate, it rocks.......