Accessing Field Value in Section Footer

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

Access 2002.I have a report that groups on the field
[Counselor]. I have a Counselor group header and group
footer. I have a control in the group footer that runs a
function that needs to access the value of the [Counselor]
field. When the code tries to access the [Counselor]
field, I get the error "Microsoft Access can't find the
field 'Counselor" referred to . . .". However, if I put a
control in the group footer that has [Counselor] as its
data source, it has no problem accessing the value. This
same phenomenon (error) occurs in the group header as
well. Why so?
 
Doug,

Where is this code being called from and when?
If it is being called by the [counselor] footer's on
format event I think it should work if it is being called
earlier ..... I'm not sure. A little more info would help
and maybe someone more knowledgeable can help.

Terry
 
Back
Top