Error mismatch in macro

[AccessThomas]

My report was running fine then I started getting errors such as
"A problem occurred while Microsoft Access was communicating with the OLE server or activex control."

I looked at the macro for the combobox and tried to run it, and it says type mismatch.

Nothing has changed in the database table.



The code in the macro where condition is
="[Account Name] = " & "'" & [Screen].[ActiveControl] & "'"

[ranman256]

Screen.activecontrol is not a string value.

[June7]

ranman, I don't understand your comment. The reference to ActiveControl is intended as a variable, not literal string.

Something somewhere has to have changed.

Might explicitly name the control that is to provide the value.

[John_G]

Since you are using a combo box, my guess is that Screen.activecontrol does not yield the value you think it does. If the combo box has a hidden column (Width = 0) as the bound column, then Screen.Activecontrol will give you the value in that hidden column, and not the text you see.

If you want to refer to the text you see in the combo box, then use Screen.Activecontrol.Column(1)

[AccessThomas]

Got it working, just had to copy everything to a new form.