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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replace one value with another when concatenting fields in a repor 9
Control can't be edited error 4
Display of a text field yy/mm/dd as mm/dd/yy in a report header 4
IS there a simple wat to create a query form 9
problem with lookup function 2
Creating a table and relationship for counseling notes question 2
Control detail section height size in Ac2007 2
How to "copy" group running total to report footer? 3

Back
Top