Results 1 to 4 of 4
  1. #1
    mcgetta is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    2

    Newbie - form updates/table synchronisation

    Total newb so apologies if this is the dumbest question ever.



    I have an inventory database that is setup with 6 tables, I have created a form view to layout the information. Intially the table had 13 records, which i then appended via an Excel spreadsheet.

    Issue is that the Form was created between the initial table setup and the appendage from Excel. Now that i have added all the other table records the form view still shows ONLY the initial 13.

    how can i update the form to reflect the current view of the Tables?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    If the form is connected to the table it will always be live. (no syncing needed)
    If the table only has 13 records still, the data did not import OR its went into a different table.
    If the form only shows 13 recs, and the table does not, then the table's rowsource is not connected correctly.

  3. #3
    mcgetta is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    2
    The table has 35 records. Only the initial 13 show on the form

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Quote Originally Posted by mcgetta View Post
    The table has 35 records. Only the initial 13 show on the form
    What is the name of the table?
    What is the Record Source property of the form?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 6
    Last Post: 11-30-2013, 02:41 PM
  2. Replies: 8
    Last Post: 06-03-2013, 03:55 PM
  3. Form no longer updates table; what'd I do?
    By SevenSignz in forum Forms
    Replies: 8
    Last Post: 03-04-2012, 12:25 PM
  4. Replies: 2
    Last Post: 03-29-2010, 11:52 AM
  5. Replies: 1
    Last Post: 03-29-2010, 04:11 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