Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010

    Unanswered: Creating headings when a field changes in a form

    I have a form that is linked to a query that sorts on the field 'FoamGrade' so all the same foams are together. But I need it to put a header in each time it changes.

    Any suggestions what I need to bone up on to figure out how to do this?
    Last edited by martinbanks; 11-08-10 at 12:33. Reason: simplified question

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    As answered elsewhere:

    Pretty simple in a report, fairly difficult on a form (no group headers). I've done it with a UNION query, where one section gets the headings and the other gets the detail, but that makes the form read-only.

Posting Permissions

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