Pass Value From Subform To Text Box Control On Other Form VBA

[Excel4444]

I have a main form that has a handful of combo boxes that the subform's query uses for results. I would like to have a double click event on the State from the subform that passes the State name that's being clicked from the qryDatasubform to txtValue on my frmOther form.


Main Form --> frmMain
Subform--> qryDatasubform
Secondary Form --> frmOther
Text Box --> txtValue


State is not the primary key. there is an ID that's the primary key already.

Thanks!

[ranman256]

ON DBL-click
forms!frmOther!txtValue = cboState

[Excel4444]

Works perfect!