Hi, all!

Have a 2003 workbook that is used to print forms. On Sheet 1 is the form
and 3 combo boxes used to select values. The data for the combo boxes comes
from Sheet 2.

User wants to automatically update the combo box list data from an Access
database, so they gave it to me (the one who uses Access the most). I have
created a table in Access to create and store the info, but have been unable
to successfully update Sheet 2. When I use transferspreadsheet method in
Access (with "Sheet2$" as the range), it erases the data in Sheet 2 but adds
the new data following where the old data ended. This makes the 3 named
ranges on Sheet 2 contain blanks.

Figure I'm not using the correct approach here. Can someone (1) suggest the
best way to do this and (2) point me to some documentation that tells me how.

Can really use the help...this is due Tuesday morning.

Thanks,
Bruce