combo box and userform

[jderrig]

Do I have to use a user form for a combo box? I have a document that has
text boxes and a few combo boxes and an update button that will load the
information into an Access database. My issue is that I have populated these
boxes by using run form but then it is blank when I open it up again. I have
tried to using userform_initialize but I don't quite understand the process
as the form pops up first thing when I open the document and the combo boxes
are lower in the document so it is confusing to have it open first thing.

This is the coding that I have:

Private Sub Education_Change()
Education.List = Array("High School", "AA/AS", "BA/BS", "Master's",
"Doctorate")
End Sub

Help would be greatful, thanks.

 

[Greg]

You can put your code in a AutoNew and AutoOpen macro.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?amRlcnJpZw==?=,

I'm not really sure I understand everything, here, but...

Yes, some ActiveX controls (from the Control Toolbox) do reset when the document
is closed (so you notice it when you open it the next time). This means you have
to run some initialization code. In Word, you can use the Document_Open event in
the ThisDocument module. Or you can include an AutoOpen macro in any module.

If you're working with a template, and new documents are being created from the
template, then you need the Document_New event or a AutoNew macro.

Do I have to use a user form for a combo box? I have a document that has
text boxes and a few combo boxes and an update button that will load the
information into an Access database. My issue is that I have populated these
boxes by using run form but then it is blank when I open it up again. I have
tried to using userform_initialize but I don't quite understand the process
as the form pops up first thing when I open the document and the combo boxes
are lower in the document so it is confusing to have it open first thing.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail