Hello,

I am very new to VBA.

I am working on a form (using a Word table), and the data on this form
ultimately needs to go into Access. It is a form that will be used over and
over to collect data from many different users. Currently, I am planning on
copying and pasting the tables into Excel and then importing this into my
Access database.

I am having a few problems.

1) I am using drop-down menus for some of the fields. Is there a way to save
the value users choose to text when they exit the field?

2) I have one drop down menu that has 17 choices (called "categories") in
it. Once a user has made a selection, I want the following drop down menu
(called "Subcategories") to be narrowed to the appropriate list of options.

3) When I copy and paste the table into Excel, I get a blank row after each
of my rows. There is no data in these rows. This only happens when I use
forms.

4) I also have bullets followed by a form field so that users can create a
bulleted field. This does not paste happily into Excel.

Are there other methods that would work better?

Thank you for your time.