open a recordset and simple do like.this is easy way to get data in
a combo box.

If Not (rs.EOF And rs.BOF) Then 'check if it is either eof and bof
rs.MoveFirst 'go to first...