Is this a form? Is it in Datasheet View?
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.
This is a form - "Multiple Items" quick form - in Form View.
(Thank you for your replies, June).
Yes, but is it Single, Datasheet, or Continuous? Look at Default View property.
I've never developed code for dynamic sort of records on form. I suppose it could set the OrderBy property.
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.
I see, it is a Continuous form.
Okay, then I presume those label headers are in the form header section. Labels have a Click event.
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.
I threw this together.....