troubleshooting Question
VBA Line causes Access to hang up.
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.Te
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?
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.Te
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?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
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.