over-ride combo box

[marley]

I have an quote request form that my customers can fill out. much of the form is combo lists that I have predetermined the content. I need to know if there is a way for the customer to over-ride the combo box and type their own entry into the box if the choice they desire is not in my predetermined database.
p.s. I am using MAC OS9 if that makes a difference.

 

[Juan Pablo González]

If you're using a Control Toolbar ComboBox, you can set the MatchRequired to FALSE.

If you're using a Forms Toolbar ComboBox, don't know if it's possible.

If you're using Data Validation, just UNCHECK the Show Error in the third tab.

 

[marley]

Thanks, I'll try those options. I am, in fact, using a Forms ComboBox, so this gives me two more options to attempt.

 

[Dave Hawley]

Hi Marley

Not sure if it would be an option, but have thought about using a Validation list?

Or, if you stick with the Forms ComboBox you could use a Dynamic range and have new entries added straight to that range, which would then incorporate the new entry as part of the CombBox "Input Range:"

http://www.ozgrid.com/Excel/DynamicRanges.htm

 

[marley]

I have swithced from a Forms Toolbar ComboBox to the DataValidation and UNCHECKED the show Error and it is working perfectly. This website is absolutely priceless. Thank you all who participate.