Question about using forms

[Laurie]

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.

 

[Graham Mayor]

http://gregmaxey.mvps.org/Extract_Form_Data.htm should be a good place to
start.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Laurie]

Wow, that looks great, thank you!

http://gregmaxey.mvps.org/Extract_Form_Data.htm should be a good place to
start.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>