The following line causes Access 2003 to hang up:
Me.ComplaintID.Text = strFilter
ComplaintID is a combobox, strFilter contains any string.
When the code reaches that line, Access just hangs, no error message. I have to go into task manager to close Access down.
I precede that line with:
Me.ComplaintID.SetFocus
I have tried other forms of the line such as:
Forms.frmPt.ComplaintID.Text = strFilter
frmPt!ComplaintID.Text = strFilter
ComplaintID.Text = strFilter
with the same result.
I have used
Me.ComplaintID.Text =
in other areas of the object module without problem.
Any ideas what is going on?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.