Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: Move text box from one form page to the next

    I am fairly new to Access and I am having a problem passing data from the first page of a form to succeeding pages. Here's the scenario:

    1. Name table contains user names (only 2 users)

    2. There is a Data table for each user containing data specific to each user (2 data tables with many entries per user)

    3. There is a separate data entry form for each user (2 forms)

    I have the user name in a text box at the top each data entry form.
    I want the user name at the top of each page for each data entry form.

    The problem is when I open a form, the user name appears on the first form page O.K., but not on the succeeding pages.
    The user table and the data table are in a linked relationship.

    Can anyone tell me how to get the text box (user name) from one page to the next?

  2. #2
    Join Date
    May 2005
    Welcome to the forums

    Have you tried moving it to the form's page header section?
    Me.Geek = True

  3. #3
    Join Date
    Mar 2009
    Thanks for the suggestion, but the result is the same. What I need to do is to capture the Name from the name table and carry it forward to each succeeding page, but I can't figure out the VBA code to do it. Also can you tell me what you mean by "I.D. ten T errors."
    Thanks for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts