combobox/textbox

[mcarter973]

in a user form, i would like the textbox to populate w/ the item chosen from the combobox - this is what i have so far:

1. tblBrokerList w/ two fields: BrokerList and Group
2. qryBrokerList (same info as above just sorted on BrokerList).
3. user form w/ Broker combobox (cboBroker) - rowsource is qryBrokerList
4. user form w/ Group textbox (txtGroup)

Private Sub cboBroker_AfterUpdate ()
txtGroup = cboBroker.Column(1)
End Sub

I'm fairly new to Access, what am I missing? Currently, the Group textbox is blank after choosing a Broker.

Thanks.

 

[bat17]

Assuming that your broker combobox is selecting the group that you want, just bind that to txtGroup rather than having a seperate textbox.

HTH

Peter