Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Form Header Field not Populating (https://www.askmehelpdesk.com/showthread.php?t=297353)

  • Dec 31, 2008, 01:36 AM
    gwallace1
    Form Header Field not Populating
    Ok after fixing so many of my complex problems, I am stumpe on a fairly simple one. I have a subform with a header section to enter data in a couple of text boxes. One for Instructor and one for The name of the class. In the detail section I have continuous forms that each contain The two text boxes.. set as "=Instructor" and one for "ClassName". The Instructor name and Class name populate fine in the first record, but not in any of the subsequent records. I tried to get rid of the text boxes in the detail section of the continuous forms and see if it would populate in each record for the table, but no luck..? Any help?

    Thanks In Advance!
  • Dec 31, 2008, 07:03 AM
    ScottGem

    A Continuous form is a special type of form. Its ONE set of controls that are displayed multiple times. Unless the control is bound to a filde in the Recordsource, it will display the same value for each record.

    Subforms are generally filtered by a value on the main form. If you are trying to further filter the subform by using unbound controls in the header, that's fine, but the controls in the Detail band need to be bound to fields in the RecordSource.
  • Jan 1, 2009, 12:32 AM
    gwallace1
    Thanks... That's what I needed to know.

  • All times are GMT -7. The time now is 09:11 AM.