Carry data from one form to another.

[Tewbrainer]

Hello everyone! I am normally pretty good at figuring stuff out with Google-fu, but this question has completely stumped me. I am building an access db for work and need it to do this:

User enters their name into a combo box (MainUser) on one form (HomePage). Then they press a button that opens a new form (NewEvent). On NewEvent, there is a combobox (User) that I would like to automatically populate based on HomePage!MainUser.



I have tried everything I can think of (default value, before update, form load...) and I know this is probably something that is painfully easy to figure out.

I appreciate any help you can give!

[boblarson]

In the button's click event which opens the form, use the OpenArgs argument:

DoCmd.OpenForm "NewEvent", acNormal, , DataMode:=acFormAdd, OpenArgs:=Me!MainUser

Then in the LOAD event of the NewEvent form, use:

If Len(Me.OpenArgs & vbNullString) > 0 Then
    Me.YourUserControlNameHere = Me.OpenArgs
End If

[RuralGuy]

See if one of Paul's solutions at the top of this link offer a hint for you: http://www.baldyweb.com/

[Tewbrainer]

Couldn't have worked better, you rock Bob!

How did I not think to OpenArgs the open button? *Smacks forehead*