Word Form Problem...

[RompStar]

Ok, I am about to throw this product into the trash can...

Ok, I made a form, a few text fields and a drop-down list.

The dropdown list doesn't work unless the sheet is protected.

The default installation of Word places the VB security setting to high.

It seems only when I change this to Medium, that I can fill out the Form.

If I remove the protection, the drop-down list stops to work, what gives ?

Will this work with the default security setting ? or am I going to have to
tell everyone who uses it to change their security setting to medium ?

:help

I am not even using any macros, nothing, I don't understand. Please help.

[mdmackillop]

Hi
Re macro security, have a look at this thread. http://www.vbaexpress.com/forum/showthread.php?t=6275
TonyJolllans gives some good advice there.

Regarding your problem, macro security should have no effect of form protection. I can run your form with it set to Very High.
You do need to protect your form before dropdowns and textboxes will function.
Regards
MD

[RompStar]

the drop down list works ? when you run it, because it doesn't work for me, only the text fields work, how are you getting the drop down list to work without protection ?

[mdmackillop]

Here is a protected copy. Password is md

Edit.
The dropdowns work here but not the text boxes. I think you need form fields rather than text boxes to use a form this way. Leyt me look into this further.
MD

[fumei]

Huh? What gives. md - the file attached has no dropdowns.

Rompstar - could you give an ACCURATE description of exactly what you want to happen. This is simple stuff really, and i am sure we can help you get what you need.

From a quick look it seems more like a job for a UserForm.

In any case, in the file attached I see NO dropdowns. I, at this point, agree with md in that this could be a use for formfields - why are you using ActiveX controls?.

Perhaps if you tell us what you want - we can help.

[mdmackillop]

Hi Gerry,
The dropdowns appear when you click on R-51, R-76 etc.

[fumei]

OK,......doh...sure, fine. But:

1. Yucky design. Using those tabs make the form jump around so much when you change things. Yuck. It should be in a table.

2. I do not understand what the purpose of the textboxes are. These are ActiveX controls. What do you want them to DO? I am not sure what the Quantity boxes are for either. What are they supposed to do?