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