Setting combo-box selection on launching.

V

Vaughan

*****Merry Christmas mighty Outlook Experts and MVPs!*****

I'm finding this a little tricky. I have designed a form based on IPM.Post
for collecting and viewing basic project data (called "Project Details").
Some of the information is populated from our business system (via DAO) based
on a Job number selected from a ComboBox. Basically, the ComboBox's column
property is populated by a multi-column array extracted from the business
system, and several other item properties are derived from that. So far so
good.

I have designed another form to record details of our various project
meetings. This also has a ComboBox whose column property is populated the
same way so that a job number can be selected. I also have a command button
to open the "Project Details" form for the job selected. This works fine if
the Project Details form has already been posted for the job in question. And
I currently have it displaying a warning message is none exists.

This is the tricky bit: Instead of the warning message, I would like to be
able to launch a new Project Details form if one hasn't been posted for the
job selected, populate the ComboBox.column property and select the same job
number as in the Meeting form. The trouble is, trying to set the job property
on the Project Details form generates an error "Could not set Column
property. Invalid property array index", presumably because I am trying to
set the Job Number before the array has been called up by the Item_Open
routine.

Obviously, then, I need to somehow populate the combobox array before I
pass the value, but I can't figure out how to code it. Any suggestions?

Thanks in advance

Vaughan
 

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