How to pass a value from one form to another? (1 Viewer)

Status
Not open for further replies.

GovtWerker

Registered User.
Local time
Yesterday, 16:02
Joined
Jun 19, 2012
Messages
10
I'm working with two FORM the first has a combo box, where a value is selected

On change
Dim NewNum as string
NewNum = Me.List45.Value

then I have this form close and open up another form .
this part works fine, but what I'd like is to take the string NewNum and pass it to the second form and populate a field on a that form. It should be possible, I'm thinking, everything I've tried will not work. Any ideas besides the obvious re-Keying it?

thanks
GovtWerker
 

MarkK

bit cruncher
Local time
Yesterday, 16:02
Joined
Mar 17, 2004
Messages
8,199
What have you tried? There are a number of ways to pull this off. The easiest, for you, will be the way that's most like something you already know. So what do you already know?

Typically, describe in greater detail what you've tried. It makes it easier to offer tips you're more likely to understand.
 

GovtWerker

Registered User.
Local time
Yesterday, 16:02
Joined
Jun 19, 2012
Messages
10
More detail:
What I've tried:
1. OnOpen event on the Second Form
Text61 NewNum = Me.List45.Value ** did nothing
2. Me.Text61.Value = " & NewNum & " ** This put & NewNum & in the field
3. Tried Control Source under the properties for second Form field- I tried setting the value to the value in the first form Forms![Bulk Funding Form Fill]![List45].Value

Forms: I'm finding I'm deficient, I mean I can set up a basic form. I'm much better at writing queries and functions to pull data that I need.
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom