Results 1 to 2 of 2
  1. #1
    ahightower is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2009
    Posts
    8

    Code to call Split Form View Datasheet

    I am trying to requery a split form views datasheet, can you anyone help with the code?

    Thanks

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Requery the form:

    From the form:
    Me.Requery

    From another form:
    Forms!FormNameHere.Requery


    The datasheet and the single view are all integrated in the form and requerying the form would be the key to requerying the datasheet. The single view is tightly controlled by the datasheet so it would not matter. However, you might need to save the PK in a variable so you can go back to that record so the single view would be showing the same record after the requery.

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

Similar Threads

  1. Datasheet view in tab only
    By cdzajp in forum Forms
    Replies: 1
    Last Post: 06-22-2011, 12:44 PM
  2. Form opens table in datasheet view
    By franklbl in forum Forms
    Replies: 9
    Last Post: 03-23-2011, 09:43 PM
  3. Replies: 2
    Last Post: 01-27-2011, 08:04 AM
  4. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM
  5. Form - Datasheet View
    By kalove in forum Forms
    Replies: 0
    Last Post: 06-20-2007, 11:29 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