Calculated fields in a form from a drop down list.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

quovadis - 29 Apr 2006 08:58 GMT

Hi
I want to have a calculated field that calculates its result from a
field that is a drop down list.
I can get the formula to work when the first field is a text field
(numeric format) but when I change that field to a drop down list the
calculated field doesnt work. The name of the field is the same in the
formula.

It appears to me that i need to change the format of the drop down list
to numeric some how but I dont know how.
Cant find anything on the Internet.

If you can help I would be greatful.

Reply to this Message

Doug Robbins - Word MVP - 29 Apr 2006 09:59 GMT

Run a macro containing code similar to the following (changing the names of
the formfields as necessary) on exit from each of the formfields that
contribute to the calculation:

With ActiveDocument
.FormFields("Text2").result = .FormFields("Text1").result *
.FormFields("Dropdown1").DropDown.Value
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi
> I want to have a calculated field that calculates its result from a field
[quoted text clipped - 9 lines]
>
> If you can help I would be greatful.

Reply to this Message

quovadis - 30 Apr 2006 03:52 GMT

> Run a macro containing code similar to the following (changing the names of
> the formfields as necessary) on exit from each of the formfields that
[quoted text clipped - 4 lines]
> .FormFields("Dropdown1").DropDown.Value
> End With

Thanks very much.

Reply to this Message

Rate this thread: