Results 1 to 4 of 4
  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    494

    Split form with spreadsheet view on top


    Is it possible to create a split form with spreadsheet view on top and when you click on any field in that line it shows a regular form with field information below?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I never use split forms.......... having said that, did you try to put the datasheet on top?


    There is a property, "Split form Orientation", that sets the datasheet to TOP, BOTTOM, LEFT or RIGHT.

  3. #3
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    494
    I was thinking it would be easy and i could then see a concise list of info in worksheet view and then when i click on a car i could see a list of organized details below.

    Why dont you use split forms?

    I already created it as a regular form with a continuous subform which is better anyway because then i can do some conditional formatting on fields.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Split forms were not available in A97 or A2K, so ...........

    From what little I tried them, they were two limiting (as you found out )

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

Similar Threads

  1. Master and Detail Split Form View
    By james28 in forum Forms
    Replies: 23
    Last Post: 07-30-2014, 02:19 AM
  2. Sorting in spreadsheet view on a form
    By PMBott in forum Forms
    Replies: 1
    Last Post: 04-27-2012, 10:01 AM
  3. Replies: 2
    Last Post: 02-27-2012, 03:02 PM
  4. Datasheet view of Split Form in a Tab??
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 12-19-2011, 04:37 PM
  5. Code to call Split Form View Datasheet
    By ahightower in forum Programming
    Replies: 1
    Last Post: 07-28-2011, 04:57 PM

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