I am writing some VBA code that will show a user form when opening the
document it is within.  The form will include a drop down (combobox) list and
a generate report command button.  I have created the document template and
placed the bookmarks necessary to place the queried FoxPro data in.  I have
ran a test without connectivity to the data to check my command button and it
works just fine.  The problem I am having is connecting to the database and
filtering certain information to the drop down list for selection and then
querying based on that selection for further database information from FoxPro.

I am using Word (Office XP/2000/2003) and VBA 6.  I was trying to connect to
the data using the vfpoledb driver, but I am having no luck it appears.  
Could anybody out there help me get started with this?  Thanks.

I have tried the various snippets out there for ADO/OleDB/ODBC, but I am
afraid it is my references that is out of whack.  Thanks in advance for any
help any of you can provide.

Michael P. Griba
West Coast Charters, Inc.
mgriba@westcoastcharters.com