Results 1 to 2 of 2
  1. #1
    SethG is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    15

    Replicate SPLIT FORM in web compatible database

    This Access database is Web Compatible and is hosted on SharePoint. I have a form with a subform that display collections of records. As you can see in the attached image, the user selects a record from the combo box which filters the form/subform below. Each record will contain more than 1 item.



    What I want to do is mimic a "Split Form". But, the last thing that is missing is being able to select an item from the subform (datasheet view) which displays several items in the record and have that item be displayed in the form. Currently, I have to use the record selector buttons at the bottom of the form to have the item I want displayed in full. But I want to be able to click the item in the subform and have it populate in the main form on this page.

    Anyone know of a solution for this?

    Thank you.
    Attached Thumbnails Attached Thumbnails Database Question.jpg  

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Presume subform is not linked to main form. Perhaps use code to set filter property of main form.

    I have seen attempts to mimic split form - don't think any have worked well.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Web compatible split form
    By SethG in forum Access
    Replies: 1
    Last Post: 04-07-2015, 11:45 AM
  2. Replies: 5
    Last Post: 06-09-2014, 01:30 PM
  3. Split Form Slows Database
    By buienxg in forum Access
    Replies: 2
    Last Post: 11-26-2011, 10:20 AM
  4. Need to replicate data in 2 tables
    By magister011 in forum Access
    Replies: 5
    Last Post: 11-02-2009, 04:55 AM
  5. Replicate Contains Function?
    By billt568 in forum Queries
    Replies: 0
    Last Post: 10-26-2009, 09:58 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