[AccessD] Set value in a report textbox

Tina N Fields tinanfields at torchlake.com
Tue Oct 30 16:37:55 CDT 2018


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
>



More information about the AccessD mailing list