By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,482 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Help on pushing data!

P: 6
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 "ProjectNumber" 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
Feb 28 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,597
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 "ProjectNumber" 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.
Expand|Select|Wrap|Line Numbers
  1. Forms![GoTeam]![ProjectNumber] = Me![ProjectNumber]
  2. Forms![GoTeam]![ProjectName] = Me![ProjectName]
Feb 28 '07 #2

P: 6
How do i set it to hidden?
Feb 28 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
It doesn't need to be hidden.
Hidden is simply one of the three valid states where this code will work :)
Mar 2 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.