Results 1 to 4 of 4
  1. #1
    accesslessio is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    10

    table on tab doesn't list all record

    Hi,
    I have a beginner problem whicdh is making me upset:
    I put on a tab of my form MacroAttività a form in a spreadsheet layout to list all the records I have in its relative table, but it doesn't show me all records, just the first. If I open the same form alone it lists me all the 6 records I have in that table. What can I do?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The master form must be set to single record.
    the tab is on the form.
    inside the tab is a sub form control.
    the sub form control is set to the spreadsheet view, (or multi record form).
    (If you set the subForm' link index field' then you MAY get 1 record. If blank, you'll get all records.)

    the master form cannot be set to continuous, if you have a tab control on it.

  3. #3
    accesslessio is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    10
    I can't find the tab for putting to a single record. Where is located precisely on the form?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i thought is was your tab. did you place it?
    the tab should be visible.

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

Similar Threads

  1. record doesn't exist
    By slimjen in forum Forms
    Replies: 7
    Last Post: 08-13-2014, 11:07 AM
  2. Replies: 4
    Last Post: 12-14-2012, 06:33 PM
  3. Replies: 1
    Last Post: 10-12-2012, 03:23 PM
  4. Lookup List in a Form for Table Record entry...
    By noaccessguru in forum Forms
    Replies: 1
    Last Post: 05-05-2011, 12:35 AM
  5. List box doesn't allow Unique data entries
    By Delta223 in forum Forms
    Replies: 2
    Last Post: 01-24-2011, 07:24 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