Load Combo Box On Form Load

[Matt]

Hi All,

I am trying to load a combo box on the form load and am using the
following code to do so:

**********************************************************************************************
Dim qry As QueryDef
Set qry = CurrentDb.QueryDefs("Social Security #'s Sort")
Combo12.Recordset = qry.OpenRecordset
***********************************************************************************************

What am I doing wrong?

 

[Van T. Dinh]

Try:

Set Me.Combo12.Recordset = qry.OpenRecordset

 

[Douglas J. Steele]

Or simply

Combo12.RowSource = "[Social Security #'s Sort]"