Error referencing a field on an open form

[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?

 

[Marshall Barton]

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

That implies that the form is no longer open or that one of
the names is misspelled.

 

[anthony]

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

 

[Marshall Barton]

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!

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.

 

[anthony]

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