[AccessD] Set value in a report textbox

[Tina N Fields]

You know, it's been a little while since I was every day in a database, 
and I totally overlooked the fact that the source data for the report 
was separate from the source data for each of the subreports. Dang! 
Thanks for waking me up.

T

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

On 10/30/2018 6:16 PM, Rocky Smolin wrote:
> And since the A name will be retrieved in your query, you can have it show
> up in a text box bound to that field.  So no code required.
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Tina N Fields
> Sent: Tuesday, October 30, 2018 3:15 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Set value in a report textbox
>
> Hmm - I'll look into that. Thanks.
>
> T
>
> Tina Norris Fields
> 231-322-2787
> tinanfields-at-torchlake-dot-com
>
> On 10/30/2018 6:06 PM, Rocky Smolin wrote:
>> If the names are in a sub-report, then the record source for that sub
> report could retrieve all the names as well as the foreign key to the
> family.  Then the sub report would be linked to the parent report by the
> FK<-->PK. So the record source for the main report would still have only one
> name and the sub report for the family would have all the names.  Minus the
> "A" name through a filter in the sub-report's query.
>> If I understand you correctly.  Which is possible. (It could happen) :)
>>
>> R
>>
>>
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Tina N Fields
>> Sent: Tuesday, October 30, 2018 2:38 PM
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] Set value in a report textbox
>>
>> 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
>>>