Results 1 to 5 of 5
  1. #1
    MAP-PROF is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    3

    Smile Add more than one record from a single table on a form

    Hello, I'm new to this forum. Just upgraded from MS Access 2002/2003 to 2010. What a jump. I have developed a database and am trying to create a form that takes its info from several tables each with two fields - Question & Response. Each table is on a separate subject and the forms are to include fields from only one form.



    When I create a form designed from a single table with 72 Questions, I get 72 records (pages). I would like to have more than one record (perhaps all of them) on one form. It sucks to have to type in the response and then click to the next record.

    Is this possible? If so, how?

  2. #2
    MAP-PROF is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    3
    Figured it out - just needed to change my form to continuous.

  3. #3
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Which views have you tried? Are you committed to form view or could you use continuous form or datasheet view? (These are options on the property sheet of the form in design view.)

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,350
    Not sure what you mean. Is the form set for SingleForm view? Maybe try Continuous or Datasheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    MAP-PROF is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    3
    Yes, I changed to continuous view - didn't even know that was an option until I googled and found out.

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

Similar Threads

  1. Export single record from a form to PDF
    By GraemeG in forum Programming
    Replies: 1
    Last Post: 04-10-2011, 01:33 PM
  2. Replies: 5
    Last Post: 03-23-2011, 10:39 AM
  3. Move a single record to an archive table
    By 10 Gauge in forum Forms
    Replies: 7
    Last Post: 02-14-2011, 06:50 AM
  4. Update single record via forum, not entire table?
    By 10 Gauge in forum Programming
    Replies: 2
    Last Post: 02-11-2011, 09:14 AM
  5. Replies: 7
    Last Post: 11-13-2010, 08:08 AM

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