Results 1 to 2 of 2
  1. #1
    spellbound is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    1

    Multiple source records for the Form

    Hello, Is it possible to have two sources of record for one form: a table and a query? I want the form to populate the table, but the form also should have some limitations (filters) set up in the query. Is it possible? Thank you!

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Only if you use a main form and a sub form. A form may only be bound to one record source.

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

Similar Threads

  1. Multiple Records On the same Form(ish)
    By Dalagrath in forum Forms
    Replies: 0
    Last Post: 03-30-2011, 11:13 AM
  2. Multiple records, one form
    By andwhy81 in forum Forms
    Replies: 16
    Last Post: 10-04-2010, 01:12 PM
  3. One Form, Multiple records
    By andwhy81 in forum Forms
    Replies: 3
    Last Post: 09-21-2010, 12:12 PM
  4. Add Multiple Records on One Form
    By William McKinley in forum Forms
    Replies: 7
    Last Post: 08-18-2010, 09:31 AM
  5. Replies: 1
    Last Post: 07-04-2010, 03:31 PM

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