Error when using dropdown

[Dinsdale]

Hi Everyone,

I have created several templates, some of which import blocks of text
and fields from master documents. In one instance, I am importing a
table containing fields (one being a dropdown) which takes the form of
an invoice. All the fields are calculating correctly except the invoice
line item dropdown. On the original, it works fine - once imported it
stops working. I have created the following code which generates Error
4241: Object required.

Dim UnitPrice1

Select Case LinePrice2
Case UnitPrice1.Value = 25.5
LinePrice2 = Qty1 * 25.5
Case UnitPrice1.Value = 32
LinePrice2 = Qty1 * 32
Case UnitPrice1.Value = 120
LinePrice2 = Qty1 * 120
End Select

 

[Jezebel]

That's not how to use Select Case. The idea of select case is to evaluate
the argument (in this case LinePrice2) against a set of comparison
functions. So what you are currently doing is equivalent to

If LinePrice2 = (UnitPrice1.Value = 25.5) then ...

Presumably there is code omitted between the declaration and the select
case; but the error implies that either you are not setting UnitPrice1 to an
object, or that object doesn't have a .Value property. The curse of the
variant!

 

[Dinsdale]

That's not how to use Select Case. The idea of select case is to evaluate
the argument (in this case LinePrice2) against a set of comparison
functions. So what you are currently doing is equivalent to

If LinePrice2 = (UnitPrice1.Value = 25.5) then ...

Presumably there is code omitted between the declaration and the select
case; but the error implies that either you are not setting UnitPrice1 to an
object, or that object doesn't have a .Value property. The curse of the
variant!

Mmm. Thanks. Wondered if I should be using if then instead.

Andrew

 

[Jezebel]

Mmm. Thanks. Wondered if I should be using if then instead.

Probably. But what is the UnitPrice1 object?

 

[Dinsdale]

Probably. But what is the UnitPrice1 object?

The name of the dropdown.

 

[Dinsdale]

Probably. But what is the UnitPrice1 object?

And I've fixed it Changed to using ActiveDocument.Formfields to
specifically refer to the field and now it all works.

Thanks for your help.

Andrew