Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009

    Unanswered: Simultaneous form view & datasheet view

    Simultaneous form view & datasheet view:

    \Hi, Hope you can help....
    My problem revolves largely around ergonomics, where records are displayed in form view, but the user also needs to see a datasheet view or "list" of all the records, not just the selected record.
    So, form view on the left, showing the selected record, and datasheet view on the right showing all the records, where the left and right views a synchronised. Moving to the next record on the left form view steps to the next record on the right, datasheet view.
    Clicking on a record on the right, datasheet view must take the left form view to the selected record. Get it?
    Fiddled with master and child, etc, no luck.. Can get the form view to display all records, but not synchronised. Can also get the form view to synchronise, but only the active record is displayed..
    Would appreciate any guidance at this time.. (Access 2003 on XP)


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    You'd have to code the synchronisation with VBA using OnCurrent, probably.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    don't use datasheet view, but instead fake it using a continuous form, but I'd suggest you don't allow users to edit the continuour form.

    you shouldn't really need the datasheet view, a competantly written search form should allow users to find the data they need.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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