Pulling field from form and adding it to a report

[bsmith]

ClubDatabase.zip



I've attached the trimmed down database to narrow down my problem. I want the "Disclaimer" field in the MyOrgInfo Form or Table to be shown in the Members ALL Data Report. That's it. I've tried adding the query for it to the report SQL --> didn't work. I tried things like =[Forms]![MyOrgInfo]![Disclaimer], but that didn't work either. I tried a bunch of different things and searched the forums, but couldn't find the clue that got me on the right track. I know the answer is super easy, I just can't see it. So I finally caved and made my own shout out for help .

Any help is much appreciated.

[pbaldy]

Works for me with:

=[Forms]![MyOrgInfo]![Disclaimer]

I had to change the popup and modal properties of the form to be able to open the report.

[bsmith]

Ok, I'll check the modal properties (once I figure out what that means) tonight. Thanks!

[pbaldy]

No problem. You can cut the form out of the picture and get it with from the table:

=DLookUp("[Disclaimer]","[MyOrgInfo]")

[bsmith]

Sooo. Finally figured out the modal and popup properties after much research. Messing aroung with this didn't seem to fix much for me, but I was probably not doing something right. I did retry =[Forms]![MyOrgInfo]![Disclaimer] and results were #error. However the =DLookUp("[Disclaimer]","[MyOrgInfo]") worked smashingly!! I had actually tried the DLookUp earlier, but I think I may have input something wrong. Thanks pbaldy you've staved off my insanity for another week.

[pbaldy]

No problem. I wish someone had staved off my insanity.

[pbaldy]

By the way, was the form open when you tested with the form reference? It needs to be.