Results 1 to 2 of 2
  1. #1
    euphonium01 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    40

    Changing form data view

    I have a simple Form to show basic Enquiry details, there is a related sub-form (Followupsbf) to show any followups to the enquiry, the forms are linked via EnqID. There's only 2 visible controls on the sub-form, ie, the Date then the Followup Info.

    I wanted to show the latest followup at the top (descending) this was easy enough. But I would like to know if it is possible to have the 'New' entry as the top row, above all the previous entries, instead of at the bottom.



    If this is possible, how would I do it? Thanks in advance of any help!

  2. #2
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    This is possible but there is no built in way to do it. Basically you have to create two continuous sub forms. One will have the Data Entry set to yes so the user can only enter new records and will be on top in the design. The other will have the Allow Additions property set to No and will be just below the first one. You can manipulate the sizing and borders to get them to appear as one sub form. Also, in the After Update event of the "new records" sub form you need to requery the second sub form. These are both based on a query that sorts the records descending. see attached example.
    Attached Files Attached Files

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

Similar Threads

  1. Graphs shrinking when changing view.
    By TrulyVisceral in forum Reports
    Replies: 3
    Last Post: 04-13-2018, 06:25 AM
  2. Replies: 4
    Last Post: 10-29-2015, 01:46 PM
  3. Replies: 5
    Last Post: 04-24-2015, 11:58 PM
  4. Replies: 2
    Last Post: 03-05-2015, 01:11 PM
  5. Replies: 8
    Last Post: 04-29-2013, 11:23 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