Results 1 to 3 of 3
  1. #1
    fr4654's Avatar
    fr4654 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2014
    Location
    Cumberland City, Tennessee
    Posts
    2

    1 Form 3 Tables same .mdb

    I need assistance on how I can make my primary form manage data from two other tables in the same .mdb.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Well, if your table is related, join the tables in a query and use the query as the Data Source for your Form.
    If your data is unrelated, you can use SubForms on your Form (one for each table). See: http://office.microsoft.com/en-us/ac...010098674.aspx

  3. #3
    fr4654's Avatar
    fr4654 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2014
    Location
    Cumberland City, Tennessee
    Posts
    2
    Thanks. The tables are related and I zoned out and didn't think. Thanks again

Please reply to this thread with any new information or opinions.

Similar Threads

  1. 1 form two tables
    By keiath in forum Forms
    Replies: 27
    Last Post: 01-28-2014, 01:17 PM
  2. Replies: 14
    Last Post: 01-26-2012, 02:20 AM
  3. one form to many tables
    By jonathanjilla in forum Forms
    Replies: 2
    Last Post: 12-13-2011, 04:01 PM
  4. 1 Form ~ 2 Tables
    By cvansickle in forum Forms
    Replies: 0
    Last Post: 03-01-2011, 04:59 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums