Type Mismatch Error



I have a series of three cascading combo boxes that have been working as
desired for months. All of a sudden, there is one set of choices in the third
combo box (cboDescription) that is triggering a "Run time error 13 -- Type
mismatch" error. All other choices work fine. When I click Debug, it
highlights the first line of the following code, which fills in a control
(Identifier) once a selection is made in cboDescription. (I have added a
requery of Identifier after this code, because at times the Identifier
control does not change if I make different selections in the combo box
series.

cboDescription After Update Event
If Not IsNull(Me(DescriptionID)) Then
Me![Identifier] = [TicketNum] & " - " & [State] _
& " - " & [ReceivedDate] & " - " & [DescriptionText]
End If

Me![Identifier].Requery

I have decompiled, compacted, and recompiled this database several times.
Does anyone have any thoughts on this problelm?
--
susan
.



Relevant Pages

  • Re: Type Mismatch Error
    ... > in the third combo box (cboDescription) that is triggering a "Run ... which fills in a control (Identifier) once a selection is made ... because at times the Identifier control does not change if I ... would only make sense if the field or control named "DescriptionID" ...
    (microsoft.public.access.formscoding)
  • Re: Win control refreshing at designtime
    ... > but I'm having a bit of trouble with updating the control at design ... > private _indentifiersas Identifier ' An array of Indentifier ... > Public Sub RefreshRtb ... > thereafter adding a handle that calls Refresh for this event each ...
    (microsoft.public.dotnet.languages.vb)
  • Win Control and designtime refresh
    ... Im currently constructing a Windows control that inherits from RichTextBox, ... but I'm having a bit of trouble with updating the control at design time. ... Public Sub RefreshRtb ... An Identifier Class holding a KeyWord as _formatCharacters and a Color to ...
    (microsoft.public.dotnet.languages.vb)
  • Win Control and update at design time
    ... Im currently constructing a Windows control that inherits from RichTextBox, ... but I'm having a bit of trouble with updating the control at design time. ... Public Sub RefreshRtb ... An Identifier Class holding a KeyWord as _formatCharacters and a Color to ...
    (microsoft.public.dotnet.languages.vb)
  • Win control refreshing at designtime
    ... Im currently constructing a Windows control that inherits from RichTextBox, ... but I'm having a bit of trouble with updating the control at design time. ... Public Sub RefreshRtb ... An Identifier Class holding a KeyWord as _formatCharacters and a Color to ...
    (microsoft.public.dotnet.languages.vb)