You should post your code that you have in your Cancel Button _Click Event
and the code that is ran to enable the Cancel Button. Since you didn't post
any code I will have to guess what you need. Try this. Hope this helps! If
so, let me know, click "YES" below.

Put this in your Cancel Button Click Event

Unload Me

--
Cheers,
Ryan


"IanC" wrote:

I have several ComboBoxes on a form.
These ComboBoxes are populated from ranges specified in RowSource.
Initially the ComboBoxes display Select as set by the Value property.
If the user selects from the available options there is no problem as the
subsequent code recognises the input.

When all the relevant data is selected, an OK button is enabled. If not,
then there is only a Cancel button.

If the MatchRequired property is set to True, clicking the Cancel button on
the form displays "Invalid property value" and the code associated with the
Cancel button fails to execute.

I suspect it is connected with each of the ComboBoxes initially containing
"Select" even though this is not in the RowSource range.

I think I have 2 options:
1. Set MatchRequired to False. Unfortunately this allows the user to type
into the ComboBox, potentially causing the subsequent code to crash.
2. Add "Select" to the range specified in RowSource. This means that
"Select" will appear in the and is a relatively minor issue.

Is there a 3rd way? Ideally I'd like to disable the option to type into the
ComboBox. I know I could use a ListBox, but I can't enter "Select" initially
unless it's in the specified range, in which case I'm better going with
option 2 as the ComboBoxes are already in place.

--
Ian
--


.