Results 1 to 4 of 4
  1. #1
    kris335 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    23

    Question 2 Fields combined to textbox not working

    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?!?!

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    Well, the form "Parent-Child Combined" will have to be open in order for that control source to work.

    What is the problem you are having? Is there an error message? What is it?

  3. #3
    kris335 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    23
    Well, if that's not a simple fix, I don't know what is! I can easily do that. I'm the only one inputting data and I'll be doing it all at the same time!

    Oh, and the error I was getting was a #Name? error!

    So let me ask then, any time I'm pulling data from another form, I have to have that form open for it to work? That's okay with me, I just wish this textbook would have told me that!!

    Thanks so much!

  4. #4
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    So let me ask then, any time I'm pulling data from another form, I have to have that form open for it to work?
    Yes, you have to have the form open for it to work.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2011, 01:28 PM
  2. Combined Reports
    By baum12 in forum Reports
    Replies: 1
    Last Post: 05-05-2011, 03:19 AM
  3. Combined Fields as Memo
    By Duval in forum Queries
    Replies: 11
    Last Post: 09-13-2010, 08:56 PM
  4. Textbox IIF statement not working
    By jgelpi16 in forum Forms
    Replies: 2
    Last Post: 08-22-2010, 08:41 PM
  5. Not sure why textbox not working for some values
    By jtkjames in forum Programming
    Replies: 1
    Last Post: 07-21-2010, 04:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums