Results 1 to 2 of 2

Thread: ACCESS 97: Detecting ORDERBY in a sub form

  1. Jun 27th, 2003, 03:25 AM #1
    stevebmartin
    stevebmartin is offline

    Thread Starter
    Junior Member
    Join Date
    Nov 2001
    Location
    UK WMids
    Posts
    24

    ACCESS 97: Detecting ORDERBY in a sub form

    I have a form which contains a subform in Datasheet view.

    The sortorder of the subform can be changed (by design) by using the standard Access datasheet menu's (right click at top of column)

    My problem is that i need to detect this sortorder when spawning a report from the form using the data...

    I hope i make sense...

    keep em peeled...
    Reply With Quote Reply With Quote
  2. Jun 27th, 2003, 02:23 PM #2
    Ephesians
    Ephesians is offline
    Hyperactive Member
    Join Date
    Mar 2002
    Posts
    424
    Use the forms property OrderBy.. if null ignore it.. if not then add it to the form recordsource when spawning the report
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width