Results 1 to 3 of 3

Thread: View entered data

  1. #1
    Join Date
    Nov 2014
    Posts
    1

    View entered data

    Access 2007: I have a database that has numerous subforms to enter information for the various steps needed to process a Corrective Action. My problem is, when I enter data in the initial subform screen I cannot view it (example: enter new record #1000 and when you hit the "last record" button it goes to 999, when at 999 if you hit the "next record" button it goes to "New" like 1000 does not exist). I have of course verified that the information is in the table - and it is - but to view it I have to exit Access and then get back in, and then the record can be viewed and is the last record when the last record button is pressed. I even made a data entry form and when I enter data via that route the results are the same. HELP!

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    After updating the subform with say record #1000 you will need to requery the subform with the following code
    DoCmd.Requery " name of your subform". This code could go in the AfterUpdate Event of the form.
    Allan

  3. #3
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86
    Allan, I have removed your email address from your signature. There are "bots" that go through sites like ours looking for valid email addresses so they can spam you to death. If you wish to share your email address with other forum members, please do so via our PM (Private Messaging) system.

    In addition, we prefer all questions and answers be publicly posted rather than sent via e-mail or PM so that everyone with a similar problem can benefit.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •