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