Can you change the table that a form is associated with in the forms properties?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kelva Noble
    New Member
    • Jan 2011
    • 2

    #1

    Can you change the table that a form is associated with in the forms properties?

    I want to copy and paste a form then change the table the form is associated with so i see the data in the new table.
  • munkee
    Contributor
    • Feb 2010
    • 374

    #2
    Yes you can certainly do this.

    Right click on the form in the database window (form not open) and click copy, then click paste and rename the form.

    Open up this new form and go in to the form properties and change the recordsource from the current table to a new table.

    Comment

    • Kelva Noble
      New Member
      • Jan 2011
      • 2

      #3
      Thank you for your help

      Comment

      Working...