Results 1 to 3 of 3
  1. #1
    TUPJK is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    17

    Access: Entries in form not showing in Table, but skipping said ID#


    OK so I am in Access 2007

    I have a Table (Table1) open and a Form (Form1) open

    The first data field for Table1 is ID (which is auto numbered)

    I made Form1 which is bound to Table1

    I am trying to use Form1 to streamline data entry for Table1

    So I have entered a few new records via Form1, but they are not showing up in Table 1

    For example say I enter ID's 15-20 on Form1... when I go to Table1 they are not there, but if I click "new record" in Table1 it will start a new record with ID# 21... so Access seems to know I have created these previous records, but they are not being displayed in the table

    Any help would be greatly appreciated
    (basically my form isn't communicating and entering stuff into my table)

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    If you close the table and reopen it the records should be there. What you have, when you "open a table" is not really the table itself, but a VIEW (albeit a system view) of the table. And just like any view/query that is open already, the changes won't be reflected unless you either close and reopen it or you requery it while it is open.

  3. #3
    TUPJK is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    17
    Quote Originally Posted by boblarson View Post
    If you close the table and reopen it the records should be there. What you have, when you "open a table" is not really the table itself, but a VIEW (albeit a system view) of the table. And just like any view/query that is open already, the changes won't be reflected unless you either close and reopen it or you requery it while it is open.
    wow I can't believe it was that easy... this has taken me a day and half

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

Similar Threads

  1. Replies: 7
    Last Post: 03-16-2011, 05:09 PM
  2. Recordset not showing alpha-numeric entries
    By rayhawk in forum Access
    Replies: 9
    Last Post: 10-29-2010, 08:15 AM
  3. Replies: 2
    Last Post: 07-01-2010, 02:53 PM
  4. people from table not showing in form
    By corystemp in forum Access
    Replies: 2
    Last Post: 03-26-2009, 08:57 PM
  5. Entries in table not showing on form!!!
    By corystemp in forum Access
    Replies: 6
    Last Post: 03-26-2009, 06:30 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