>I'm trying to tie the same combo box to different data sources programmatically. Sort of a reusable combo box. Different actions make the combo box do different things. Here's what I've tried:
>
>1 thisform.cmbTemp.Style = 2
>2 thisform.cmbTemp.RowSourceType = 6
>->3 thisform.cmbTemp.ControlSource = queries.name
>4 thisform.cmbTemp.RowSource = name
>5 thisform.cmbTemp.visible = .t.
>
>The table is 'queries' and the field is 'name'. I'm simply trying to list all of the names in the combo box. Queries is an alias that is open at the time of instantiation.
>
>Here's what I get:
>
>With RowSourceType = 2 or 6
>
>"The data source for this object must be a variable reference." on line 3.
>
>Any Ideas?
>
>Tom Welch
Did you try this?:
thisform.cmbTemp.ControlSource = "queries.name"
thisform.cmbTemp.RowSource = "name"
Note the quotes. HTH