SELECT the data into a single cursor then bind the control to it.
>Hi,
>
>I want to display two related table fields in a combo box,
>For example there are two tables
>DISTRICT and STREET
>set the relation DISTRICT.districtid into STREET
>
>I want the combo box display for selection as follow:-
>
>DISTRICT.districtname, districtid, STREET.streetname
>
>What RowSource and RowSourceType should I set ?
>
>Please advise.
>
>Thanks.
>Derek Yim
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer