The problem APPEARS to be that you are using controls from the CONTROL
TOOLBOX. Are you? If so...use the ones from the Forms Toolbar.
Granted, there won't be an article in there that says "if you are
using a drop down and your code isn't travelling...this is what you
are doing wrong"...but there ARE many tutorials (Start with the series
called "Please Fill out this Form") that show you how to properly use
the drop down form field from the forms toolbar.
But you need to answer my question for me to know if this is the
problem for sure...what toolbar are you using to add your drop down?
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free MS Tutorials:
http://www.mousetrax.com/techtrax
Free Word eBook:
http://www.mousetrax.com/books.html
Optimize your business docs:
http://www.mousetrax.com/consulting
Learn VBA the easy way:
http://www.mousetrax.com/techcourses.html
I am using the controls from the form menu (View/Toolbars/Forms). I even deleted the dropdowns and added them in again to be sure.