Shauna,

Thanks for the link...it looks straightforward, but for some reason I'm not
getting anything in my drop down box.

Here are my project specifics:
VB Version: 6.3
Office Version: 2003
Excel File: C:\Work\schools.xls
Named Range: School_Names A1:A201 (Cell A1 is the header)
Word File: C:\Work\SchoolTemplate.dot
Form Name: SchoolForm
Combo Box Name: SchoolField

Here's the code:

Private Sub SchoolForm_Initialize()

   Dim db As DAO.Database
   Dim rs As DAO.Recordset
   Dim NoOfRecords As Long

   ' Open the database
   Set db = OpenDatabase("C:\Work\Schools.xls", False, False, "Excel 11.0")

   ' Retrieve the recordset
   Set rs = db.OpenRecordset("SELECT * FROM `School_Names`")

   ' Determine the number of retrieved records
   With rs
        .MoveLast
        NoOfRecords = .RecordCount
        .MoveFirst
   End With

   ' Set the number of Columns = number of Fields in recordset
   SchoolField.ColumnCount = rs.Fields.Count

   ' Load the SchoolField with the retrieved records
   SchoolField.Column = rs.GetRows(NoOfRecords)

   ' Cleanup
   rs.Close
   db.Close

   Set rs = Nothing
   Set db = Nothing

End Sub

The form loads, but the combo box won't populate.  Any ideas what I'm missing?