Yes. A bound textbox on the header only reads the first record in the detail section. The detail section loops through all records one at a time.

If you create a detail header, sort it, and then the detail header will read the first record in the detail section, which should be the sorted for value anyway.

If you want to send a value to the text box on the top of the form, then use an unbound text box and send the value from the detail section on format event like:

If me.cmp_etc Then
   Me.txtBoxonHeader = "Something"
   Else
   Me.txtBoxonHeader = "Something Else"
End If



mmcdonal

This last one might not work too well if there are many different values.
If you can send the db in a zipped file and explain what you are trying to get...


mmcdonal

I wish I could share the DB, but I can't. I'm a contractor here and can't share anything.

I think I'm on the right track now. How do I reference a datafield from the recordset from within the Detail code?

I can tell you how to reference a "datafield" in the detail section, but I am not sure what the whole question means. Maybe we can take this offline. Please email me.

mmcdonal