ComboBox FieldNames and ComboBoxValues

[detrie]

Hello All

I have a form with 2 comboboxes

cmbFldA
cmbValueA

cmbFldA uses DAO to list field names of “Table1”
I would like to fill cmbValueA with the data contained in the field selected in cmbFldA FROM Table1.

It seems everything I’ve tried results in cmbValueA displaying the field name.


Thanks

 

[WayneRyan]

detrie,

Use the BeforeUpdate event of cmbFldA:

Me.cmbValueA.RowSource = "Select " & cmbValueA & " From Table1";
Me.cmbValueA.Requery

Wayne