Passing a value from one form to another

[GovtWerker]

I'll try again.

I have two forms:
What I'd like to do is have a value from a Combo Box pass to another Form and populate a field within that form, so more fields can be updated with additional data to complete a new record.

1. I tried setting the value of second Form field to the first Form Field
2. Me.list45.value = the second form and field
3. tried setting control setting = to query that also uses the value

from the first form field (the query works fine) =[Ending alance1]! [Document_Number]
4. oh tried the Access help button, which BTW I find generally unHelpful.
5. Searched the this forum.
6. Googled this question thinking I might get lucky (I didn't)
7. I think I'd better pick up and Access 2007 book

Has anyone done this? If so how?

 

[mdlueck]

Two quick suggestions how to pass a value between forms:

1) Use the Form's OpenArgs method, which dictates that you only pass one string type value.
2) Use a VBA Global Variable, which can be any data type, and you can have multiple.

 

[GovtWerker]

It worked on the first try!