Modify a custom field that references a lookup table

[Morne Taljaard]

Hi there,

I'm trying to change the value of a custom field in VBA (Project 2007),
that references a lookup table, but I keep getting an error "An
unexpected error occurred with the method"

I'm using the following piece of code:

Call
ActiveProject.ProjectSummaryTask.SetField(FieldNameToFieldConstant("SETA
Project Number"), "Status.Approved")


- SETA Project Number is the custom field
- In Status.Approved, Status is the lookup table and Approved one of the
lookup values.

Thanks
Morne

 

[Jan De Messemaeker]

Hi,

Haven't had the time to test this, but I feel this should read "Approved"
rather than "Status.Approved"
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Morne Taljaard]

I get the same error on "Status.Approved" and "Approved"

I got the info about the dot notation from Larry's blog
http://blogs.msdn.com/lduff/archive/2006/08/23/715531.aspx

 

[Morne Taljaard]

I got this working.

The problem was me! I need to learn how to spell, read and compare
values. One bloody underscore......

lol