Correct, a one-off form cannot run code at all. It that's not the problem, then you need to examine your code to determine why the code that sets the combo box is being skipped.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


wrote in message ...

Thanks for your response. Would "one-offing" the form cause all the
code on all tabs to cease to work? The reason I ask is that there are
two tabs within the form and the code and combo boxes on the main
"message" form still work correctly, it is only those on a second tab
that are now blank. If "one-offing" causes all code to stop working
then I don't think that can be the cause of the problem, but if it is
specific to only one tab, then it could be the cause.


"Sue Mosher [MVP-Outlook]" wrote in message ...

If the form runs code when you use Run This Form in design mode, but doesn't run code after you have sent or saved an item using the published form, you probably have done something to "one-off" the form. Outlook will not run code on one-off forms
wrote in message ...
Hi,

I have a form that populates several combo boxes from an Excel
spreadsheet. This has worked correctly for some months now. However,
I recently removed an unrelated text box and have found that the combo
boxes are now blank and are not being populated.

I initially assumed that this had caused a problem and that I would
need to change some of the code. However, The strange thing is, if I
select the published form from the "Open forms" menu option in
Outlook, the combo boxes are blank, but if I then enter design mode
and then immediately run the form again, the combo boxes are now
populated correctly. Therefore I can't see what is wrong with the
form or code as such, since it does work if I run it in this way.

Any advice would be greatly appreciated!

Thanks very much,

Adam