Change Form's table name

[Guest_imported]

Hi, guru,

If I have a Form relate to one table, and I want to rename that table, how can I keep the relationship between this Form and table?

Thank you very much

 

[Lightning]

Go into the forms Design view and open the Form's Property sheet. Change the Record Source property to the new table name.

This assumes that the ONLY change is the table name, not the table structure or field names.

HTH
Lightning

 

[jebry]

Hi!

After renaming the table go to the form's properties window and change the RecordSource on the Data tab to the new name.

hth Jeff Bridgham
bridgham@purdue.edu

 

[wacks]

Rename the table. Change the Record Source of the Form Properties.