Results 1 to 10 of 10
  1. #1
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28

    Data in Form & Table not showing, but is showing in report

    Hi. I'm a beginner database designer. I have a database set up with two tables. One for Accounts and one for Deposits. I have a Form for the Accounts with a Subform for the Deposits. Each week I enter the weekly deposits on a specific date in my subform (new records in the subform). I then run a report to show all deposits made for that date.

    I recently entered data in the subform for a specific date. When I run the report to show data entered for that date all the data is there, but when I go to the form or table the data is not showing. Please help.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It has to be saved somewhere. Do you have another table? Have you looked in both tables?

  3. #3
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28
    ok, yes the data is showing in the deposits table. How to I get it to show up in the form?

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Yep sounds like your Accounts and Deposit tables are not linking. Make sure every Deposit record has an AccountID from the Accounts Table.

  5. #5
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28
    yes, all the Deposits have AccountID's from the Accounts table.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you have the two tables linked and Referential Integrity enforced? Is your form using a query of the two tables as a RecordSource?

  7. #7
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28
    OK, I just saw what's happening. It looks like when I enter a new record in the subform it's putting the data at the top of the form instead of the bottom. How to I fix that?

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can sort the records descending maybe.

  9. #9
    cshipley83 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    28
    Thanks for your help I was able to fix it. In design view I selected the subform. In the properties for the subform, All Tab, Order By says DATE and Order By On Load says Yes. This allows my new entries to be at the bottom. Thanks again for your help.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent. Thanks for posting back with your success and solution. I used the Thread Tools at the top of the thread to mark this thread as Solved.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-29-2014, 01:04 PM
  2. Replies: 5
    Last Post: 05-09-2014, 02:38 PM
  3. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  4. Replies: 4
    Last Post: 12-14-2012, 03:42 PM
  5. Replies: 2
    Last Post: 04-29-2009, 11:50 AM

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