Returning query field names in a combo box (1 Viewer)

[rincewind_wizzard]

Hi all,

I'm not even sure this is possible.

I have Combo Box 1 which selects from a list of queries in the database

Is it possible, in the next Combo box, to return a list of the field names in the query selected in Combo Box 1?

Cheers for any help on this.

Paul

 

[Ranman256]

cboBox1.Recordset.fields

 

[rincewind_wizzard]

I've put that in the both the control, and then the row source for the second combo box (named the first one cboBox1), but no joy. Tried it with an = before the statement, and without

 

[Minty]

On the combo there is an 3rd option for the row source type - FieldList.
So if you changed the rowsource in cboBox2 to the name of the query in the afterupdate of cboBox1 and had that setting , I think Bob would be your uncle.

 

[rincewind_wizzard]

Cheers guys, I got it to work by putting this in the on enter event of ComboBox2

Me!ComboBox2.RowSource = Me!ComboBox1.Value