Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: How can I change the table link of a from?

    I have an Access 2003 database. In one of the form, I want to change the table? Currently this form is link to table "items" and I need to link this form to another table "new_items"

    Please help me.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by smartcard View Post
    I have an Access 2003 database. In one of the form, I want to change the table? Currently this form is link to table "items" and I need to link this form to another table "new_items"

    Please help me.
    To change the table a form uses(is is called bound with), you will need to update the form's Record Source property.

    Hope this helps ...
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •