[AccessD] Set value in a report textbox

[Tina N Fields]

Hi again,

Having explained all that, what if I make a separate query that does 
just select person "A" from the household and set my unbound texbox, 
which I'll name txtParentName, to the PE_Fname of the person where PH_HH 
equals HH_ID?  Wouldn't that work? Now, to figure out the syntax for 
that code.

T

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

On 10/30/2018 5:37 PM, Tina N Fields wrote:
> Hi Rocky,
>
> Yeah, that's true, but I need all the other people in the household 
> for the rest of the report. So, it's something like this.
>
> At the top is the assigned family number, the household name, whether 
> the household is participating in the Thanksgiving meal or the 
> Christmas programs, if Christmas the date and time of pickup appear 
> (they remain invisible for Thanksgiving because it's a meal and not a 
> scheduled pickup), and there may also be a gift card assigned to the 
> household. This last is going to change also, because there could be 
> more than one, so there will be a list box here.
>
> Below that are three sub reports. The first one is about food baskets, 
> that's a yes or no checkmark The second is about Toy Shop gifts 
> received, where the name, age, and gender of the child appears 
> followed by space for writing in indications of type of gifts, plus a 
> textbox (which is going to have to become a listbox) for any gift card 
> assigned to that child. The  third is for the Teen Angels where only 
> teens are listed - again it's name, age, gender, space for writing in 
> number of gifts, and a textbox (will become a listbox) for any gift 
> cards.
>
> So, I have to find a way to put that person A first name up at top, 
> but I also need to have all the other names.
>
> I thought I could put an unbound textbox and populate it when the 
> report is Active with the PE_Fname, with PE_Fam-spot of "A", where 
> PE_IDHH equals HH_ID. But, dang it, I am not figuring out how to do that.
>
> Thanks for helping me think.
>
> T
>
> Tina Norris Fields
> 231-322-2787
> tinanfields-at-torchlake-dot-com
>
> On 10/30/2018 5:15 PM, Rocky Smolin wrote:
>> Enter criterion for field PE_Fam-spot of "A"? You'd get all the 
>> Households and only one name per.  Unless more than one person has 
>> "A" rank.
>>
>> HTH
>>
>> R
>>
>>
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
>> Of Tina N Fields
>> Sent: Tuesday, October 30, 2018 2:04 PM
>> To: ACCESSD
>> Subject: [AccessD] Set value in a report textbox
>>
>> 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
>>
>