List box on one form to combo box on another form

[Brian Paul via AccessMonster.com]

have a list box called "list102" on a form called "MainForm" and I would
like to use the double click event property on "list102" on the "MainForm"
to
hyperlink to another form called "TeamMenuPopup" and automatically fill in a
combo box named "combo 78 with the name of the team that I select on the
"MainForm"" and fill in the combo box with the team name on the
"TeamMenuPopup" form. I dont want to use a combo on the first form
"MainForm" Its also not a multiple select either. I posted this question on
the microsoft access site and got a strange answer when the guy thought I
wanted to multiselect in a list box and show multiselect on a combo box on
another..go figure...thanks, any help would be greatly appreciated.

 

[Carl Rapson]

have a list box called "list102" on a form called "MainForm" and I would
like to use the double click event property on "list102" on the "MainForm"
to
hyperlink to another form called "TeamMenuPopup" and automatically fill in
a
combo box named "combo 78 with the name of the team that I select on the
"MainForm"" and fill in the combo box with the team name on the
"TeamMenuPopup" form. I dont want to use a combo on the first form
"MainForm" Its also not a multiple select either. I posted this question
on
the microsoft access site and got a strange answer when the guy thought I
wanted to multiselect in a list box and show multiselect on a combo box on
another..go figure...thanks, any help would be greatly appreciated.

In the DblClick event of the list box, use DoCmd.OpenForm to open
TeamMenuPopup and pass the selected team name in the OpenArgs parameter:

DoCmd.OpenForm "TeamMenuPopup",,,,,,Me.list102

Then, in the Load event of TempMenuPopup, put that value into the combo box:

If Not IsNull(Me.OpenArgs) Then
Me.combo78 = Me.OpenArgs
End If


Carl Rapson

 

[Brian Paul via AccessMonster.com]

have a list box called "list102" on a form called "MainForm" and I would
like to use the double click event property on "list102" on the "MainForm"

[quoted text clipped - 9 lines]

wanted to multiselect in a list box and show multiselect on a combo box on
another..go figure...thanks, any help would be greatly appreciated.

In the DblClick event of the list box, use DoCmd.OpenForm to open
TeamMenuPopup and pass the selected team name in the OpenArgs parameter:

DoCmd.OpenForm "TeamMenuPopup",,,,,,Me.list102

Then, in the Load event of TempMenuPopup, put that value into the combo box:

Thanks for the response, Will give it a whirl