Irregularities with VBA and forms

S

Sam

I have programmed a series of macros that open forms in Project Professional
2007. These forms display text boxes combo boxes that populate with fields
from the current project. About 20% of the time I run these macros and the
controls fail to display the project information and are left blank. If I
stop the macro and rerun the macro the controls are populated.

The command that I use to populate these controls is:
cboDivision.Value =
ActiveProject.ProjectSummaryTask.GetField(FieldNameToFieldConstant("Division"))

At the end of the macro I have also have a command to hide the form. Once
again, about 20% of the time this code fails to execute and the form remains
displayed after it has run. If I try to debug this error to verify that the
form hide command is run I don’t get the error.

Has anyone else experienced these types of irregularities?
 

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