I am trying to do a similar thing, trying to populate a combo box with the data in a table in Access.
I have been looking for info and the best thing I have found is DDERequest (a word command), or a GetObject (another word command).
I found these to be very poor and couldn't get the DDERequest method to work.
If you find an easy way of doing this please let me know. If I find a way of doing it I will let you know.
Mark.