Type Mismatch Error NEED HELP

[gxm100]

Hi Everyone,

I'm get a type mismatch error in my project and I'm really not sure what I'm missing (think I've just been staring at it too long).

Please see the attached file. Click the 'create shipment' button and then select from the "ultimate consignee" combo box. This will create the error. The issue seems to be with the below line of code:

Please Login or Register  to view this content.

The goal is to have the Change of that combo box populate the field "Ship To" with the associated address from the "CustomerDB" worksheet. A fresh set of eyes would be appreciated. Thanks!

[Fluff13]

because the values are strings you need to remove the CLng

Please Login or Register  to view this content.

[gxm100]

Duh - Fluff you're the man every time!

Thanks!

[Fluff13]

You're welcome & thanks for the feedback