combo box record source

[Tom]

Ideally I would like to be able to change the
recordsource of a combobox at runtime. Is this possible
and if so an idea of the required code would be
appreciated.

Tom

 

[Dale Fye]

Yes, it can be done easily.

For example, you might have a combo box that lets you
select one of several fields from your table. Then, you
have a second combo box that lists the unique values from
that field.

Private Sub Combo1_AfterUpdate

Dim strSQL as string
strSQL = "SELECT DISTINCT " & me.combo1 _
& " FROM yourTable"
me.combo2.rowsource = strsql
me.combo2.requery

End sub

 

[Douglas J. Steele]

Me.nameofcombobox.Recordsource = "sql string to use"

 

[Randy]

You can change this at any time. Set the RowSource
property to any valid SQL string.