Hi Phil,
Your code isn't commented, and your problem description is a bit short. What
is the code in the _Change event supposed to be doing?
> using the code below populates a combobox from a external table in a word
> doc
[quoted text clipped - 29 lines]
> Next i
> End Sub
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 :-)
Phil - 29 Mar 2005 03:39 GMT
hi Cindy
the code in the change event populates combobox2 depending on what has been
selected from combox 1
the problem is that if you want to type your own information into either
combox you type a letter then the code opens the external file looking for
somthing begining with the letter you typed this happens every time you type
a letter is there a way to prevent this from happening
> Hi Phil,
>
[quoted text clipped - 43 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
Cindy M -WordMVP- - 30 Mar 2005 09:51 GMT
Hi Phil,
> the code in the change event populates combobox2 depending on what has been
> selected from combox 1
> the problem is that if you want to type your own information into either
> combox you type a letter then the code opens the external file looking for
> somthing begining with the letter you typed this happens every time you type
> a letter is there a way to prevent this from happening
Don't use the Change event, I'd say. What are you using the external file for?
Could you use the event that triggers when the user leaves the combobox
control?
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 :-)