Results 1 to 5 of 5

Thread: Access

  1. #1
    broberts
    Guest

    Access

    If you create a form from a table and later need to include information from another table, can you add it to the form? I can't figure out how to do this.

    Thanks for your help.

    Access 2000 SR1

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access

    First, base your form on a query rather than on a table. Then all you have to do is add the additional table to the query and join the two tables appropriately. After that, the fields in the second table will be available for you to show on your form.
    Charlotte

  3. #3
    broberts
    Guest

    Re: Access

    yes, I could do that but I would lose the whole form that I've already created and have to start from scratch. I wanted to add info from a table to an existing form without having to recreate the form.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access

    You won't loose the form. Just open the form into design view, select Edit | Select Form, then click the Properties button. Click the Data tab, then change the Record Source from the original table to the new query. Assuming you don't change any of the existing field names, the form should function just as it did when it was linked to the table.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  5. #5
    broberts
    Guest

    Re: Access

    thanks for the tip. I really didn't want to waste all that time to create another form.

Posting Permissions

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