i have gained access to my database using the below
code but what i want to do is load my query result of all
the interviewers into my combobox named cmbInterviewer
now this is where i get stuck
thankyou for all yor replys





Code:
Dim dyna As Recordset
Dim theerror As Long

SQL = "select interviewername  from interviewer"
    Set dyna = db.OpenRecordset(SQL, dbOpenDynaset, dbSQLPassThrough + dbSeeChanges)
        theerror = Err
On Local Error GoTo 0

cmbInterviewed.Clear

Select Case theerror
Case 3146
'case 3146 means there are no records in the database

Case 0
'this is where i want to put my coding