Possible to update priority field based on another field change?

F

Falcon

I have a custom value list for the 'Text1' field - and based on what value is selected I would like to change the 'Priority' field to a specific number. Is this possible?

I'm very familiar with VB - I just can't figure out how to catch the Text1.Changed event to automatically update the priority field. Any help would be appreciated. Thanks!
 
W

William Raymond

Hi Falcon,

You will definately have to do this with code as there is no "On Change"
event (although you could probably build one). The easiest solution is to
add your code to the project in the "Before Save" event. Just before the
project is saved, you can step thru the tasks and update the Priority field.
You could also create a button on the toolbar to let people manually run the
code if they want to see the immediate results without saving.

Does this option work for you? If you need help writing the code, please
post the specifcs on the microsoft.public.project.developer group.

-Bill

--
Bill Raymond
Microsoft Project MVP
projectnation at hotmail dot com


Falcon said:
I have a custom value list for the 'Text1' field - and based on what value
is selected I would like to change the 'Priority' field to a specific
number. Is this possible?
I'm very familiar with VB - I just can't figure out how to catch the
Text1.Changed event to automatically update the priority field. Any help
would be appreciated. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top