Linking a form to a different table

[sarny]

Is it possible to assign a form to a different table. The fields would all correspond, i just need all the data entered to go a different table than the one i created the form with.

 

[The Member]

Sad But True, it is possible.

You could in fact have a few way to make this up. Say using Subform and Tab, Make the subform and use tab wizard.

Otherwise, you can make a field bound to a different source by VBA, with the RowSource property....

By far I think the first option is easiler but the second could be a real good exercise.

JL

 

[pcs]

sarny,

unless you have hard-coded refs. to the table in some VBA, you can likely go to the Form properties sheet, click the Data tab, and change the Record Source to the desired table. this assumes the field names are the same in both tables...

hth,
al