If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error referencing a field on an open form
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? |
#2
|
|||
|
|||
Error referencing a field on an open form
anthony wrote:
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. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Error referencing a field on an open form
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 |
#4
|
|||
|
|||
Error referencing a field on an open form
anthony wrote:
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. -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
Error referencing a field on an open form
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 |
Thread Tools | |
Display Modes | |
|
|