Blocking User Text in ComboBox Problem

[ortizimo]

I have 2 programs that use the code below to block users from entering text into a comboBox:

Private Sub comboBox_KeyPress(KeyAscii As Interger)
KeyAscii = 0
End Sub

One works fine while the other gives me the error below:



"The expression On Key Press you entered as the event property setting produce the following error: Procedure declaration does not match description of event or procedure having the same name"

I've tried different versions of the code and does the same thing. The comboBox has its own table and has a relationship between the main table and the comboBox.

[ranman256]

did you see if there were 2 : Private Sub comboBox_KeyPress routines in the code?

(ctl-F to find them)

[ortizimo]

actually there is nothing else but that routine...and now i wrote a cancel routine instead of using the macro and it says:

"A problem occurred while the program was communicating with the OLE server or ActiveX control"

[Micron]

Wouldn't setting the Limit To List property to Yes be simpler?

[davegri]

That error usually means that you have linked an event from the combobox to code that calls the combobox by the wrong name. Make sure the combobox control name matches the event code name.
Private Sub comboBox_KeyPress(KeyAscii As Interger)

[ortizimo]

Any code I enter comes up with some strange error. I started from scratch and enter code without any issues so I guess its fixed. There are no other comboboxes, etc with the same name...its in macro it works fine...anything else errors out. Thanks everyone.