Hi! I had an online Access class this past summer in order to make our county's Christmas program run smoother. I spent all summer designing it and putting in mock info but now that the program has actually started and I'm feeding in live data, I'm getting a few glitches. I will post them separately.
Thanks in advance for any and all help!
I have to keep track of parents, children and business so I have 3 tables. There is a single form each for parents & businesses. I have several different forms for the children tho because I have to print the data out differently at different times.
So on one form, I am picking up First Name & Last Name from the Parent form and combining it into an unbound text box onto a form based on the child table.
What is weird is that it works sometimes, other times it doesn't. Here is my control source format:
=[Forms]![Parent-Child Combined]![First Name] & " " & [Forms]![Parent-Child Combined]![Last Name]
Any ideas?!?!