Help on pushing data!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bronen
    New Member
    • Feb 2007
    • 6

    Help on pushing data!

    I need a step by step instruction to do the following (i'm a beginner):

    1) I have a form with two unbound text boxes.
    ProjectNumber, ProjectName

    2) I have a form called "GoTeam" with two regular text boxes assigned to fields in the table labeled "ProjectNum ber" and ProjectName.

    I want to have a command button on the first Form that takes the data and "sends" the data to the GoTeam form and populates the table for GoTeam.

    So if i enter '12345' in the ProjectNumber unbound text box on Form1 and click the button, it'll send that '12345' to the GoTeam field ProjectNumber.

    I need exact code. Microsoft is not helping me much.

    Thanks

    Ben
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by bronen
    I need a step by step instruction to do the following (i'm a beginner):

    1) I have a form with two unbound text boxes.
    ProjectNumber, ProjectName

    2) I have a form called "GoTeam" with two regular text boxes assigned to fields in the table labeled "ProjectNum ber" and ProjectName.

    I want to have a command button on the first Form that takes the data and "sends" the data to the GoTeam form and populates the table for GoTeam.

    So if i enter '12345' in the ProjectNumber unbound text box on Form1 and click the button, it'll send that '12345' to the GoTeam field ProjectNumber.

    I need exact code. Microsoft is not helping me much.

    Thanks

    Ben
    NOTE: In order for this to work, Form GoTeam can be Open, Minimized, or Hidden. It cannot, however, be closed.
    Code:
    [B]Forms![GoTeam]![ProjectNumber] = Me![ProjectNumber]
    Forms![GoTeam]![ProjectName] = Me![ProjectName][/B]

    Comment

    • bronen
      New Member
      • Feb 2007
      • 6

      #3
      How do i set it to hidden?

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32662

        #4
        It doesn't need to be hidden.
        Hidden is simply one of the three valid states where this code will work :)

        Comment

        Working...