[AccessD] Set value in a report textbox

[Tina N Fields]

Hi again, with thanks to both Rocky and Stuart,

Well, this one is fixed. My mistake was, as usual, not thinking forward 
for my client. I had asked at the outset about the name to appear on the 
top of this report. No, no, because we're trying to be thoughtful and 
confidential about people and their needs, we want only the family name 
to appear up there - we have the assigned family number so we can always 
go look up the details. The query I built for the overall report I also 
used as the source for the subreports - lots of info crammed into just 
that one query. That was my error. Fixed the problems by making separate 
queries, so just the "a" person is in the report query, and all the 
persons are in the subreport queries. The report now has the full name 
of the "a" person of the household at the top.

Thanks again to you both for helping me to wake up my brain.

T

Tina Norris Fields
231-322-2787
tinanfields-at-torchlake-dot-com

On 10/30/2018 5:04 PM, Tina N Fields wrote:
> Hii,
>
> I have a report for my local Salvation Army, that is to be a signature 
> sheet for the family picking up the Christmas stuff.
>
> When we developed it, they wanted only the household name and the 
> assigned family number to be displayed at the top of the report. Turns 
> out, though, they'd really also like the first name of the parent of 
> the household.
>
> The tblHouseholds doesn't have any  person names in it, of course. So, 
> I want to put a textbox alongside the Household name box to be 
> populated with the first name of person A in the household. The 
> tblPeople has the foreign key matching the household ID. (Using John 
> Colby's naming convention, HH_ID from tblHouseholds is foreign key 
> PE_IDHH.)
>
> How do I do this? I have the PE_Fname in the query, and I have the 
> person's rank in the family (they insisted on this), so each 
> individual's record has a PE_Fam-spot field.  How do I display the 
> PE_Fname of the person with the PE_Fam-spot of "A" where PE_IDHH 
> equals HH_ID?
>
> It feels as though this should be simple, but I'm just not getting it.
>
> Thanks for any help you can give me.
>
> T
>