Error referencing a field on an open form

  • Thread starter Thread starter anthony
  • Start date Start date
A

anthony

I have an open form with data displayed. I need some of that data in a
report. My report, which is bound to a table, has an unbound control
into which is typed:

="Please bring " & [Forms]![frmNewChildGuide]![txtChild]

This produces an error on the report's page. If I type the same thing
into the immediate window, the result displays correctly

The "Please bring" will display on its own but as soon as I add the
reference to the form, I get #error

What am I doing wrong?
 
anthony said:
I have an open form with data displayed. I need some of that data in a
report. My report, which is bound to a table, has an unbound control
into which is typed:

="Please bring " & [Forms]![frmNewChildGuide]![txtChild]

This produces an error on the report's page. If I type the same thing
into the immediate window, the result displays correctly

The "Please bring" will display on its own but as soon as I add the
reference to the form, I get #error
Click to expand...


That implies that the form is no longer open or that one of
the names is misspelled.
 
Well, a reboot has cured the problem which is irritating as I spent a
lot of time scratching my head over this. I couldn't see why success
in the immediate window wouldn't replicate on the damn report!

Thanks, as usual, for your help and advice
 
anthony said:
Well, a reboot has cured the problem which is irritating as I spent a
lot of time scratching my head over this. I couldn't see why success
in the immediate window wouldn't replicate on the damn report!
Click to expand...


That doesn't add up in my book. Keep you eyes open for
other anomalous happenings, this problem may(?) be the first
symptom of some kind of corruption.
 
You might well be right. I had a lot of trouble with Access when I
used the Google Desktop index. When I removed Google Desktop
everything improved. I've since installed the Microsoft version
(Instant Access, I think) so I'm now nervous again
 
Back
Top