Run Time Error 380

[Irish_Wertzy]

This is an VBA question from Excel, but I am hoping the access experts will have an answer.

I have a set of three cascading comboboxes (cbo3.RowSource is based on cbo2.Value, and Cbo2.Rowsource is based on cbo1.Value, and cbo1 Rowsource is based on a range in my excel spreadheet)

Everything works fine, as long as I don't begin typing in a combobox and enter a letter that is not in the cbo1 (or cbo2) rowsource list.

For exmple, if I have AA, BB, and CC as my options in my combobox, but I begin typing D (or AB), I get a "Run Time Error 380 Could not set the Rowsource property. Invalid Property Error."

SO, I am either looking for a solution for that problem, or an error code that at least does not require me to close the whoe sheet.

TIA

Irish

 

[noboffinme]

Hi Irish_Wertzy

Sounds like this is built in MS Access?? & not Excel, is that right?

If this is in Access, can't you set the Combo Box properties to 'Limit to List'? This will give the Users a easy to understand message that the value in not permitted.

If you're using Excel & use a Data validation list, it will also warn the User.

Let me know if I've missed something, Cheers