<div>
The control source of ComplaintID is a long referencing the key field of a linked table. By entering the text property of ComplaintID, I am trying to fire the not in list event of ComplaintID which creates a new record in the linked table and then requeries ComplaintID with Response = acDataErrAdded.<br />
<br />
strFilter contains any string. I have tried several different strings from a zero length string to a string of the maximum length of the displayed field for ComplaintID.<br />
<br />
I do have: <br />
Me.ComplaintID.SetFocus<br />
Me.ComplaintID.Text = strFilter
</div>


<div>
I found where the problem is. &nbsp;I have a do loop in the not in list event of ComplaintID that is not completing. By explaining what is happening to all of you, I realized I needed to step through the code. So now I need to fit the do loop. Thanks to all who responded.
</div>


<div>
<div class="content wysiwyg-content">
The following line causes Access 2003 to hang up:<br />
&nbsp; &nbsp; &nbsp; &nbsp;Me.ComplaintID.Text = strFilter<br />
ComplaintID is &nbsp;a combobox, strFilter contains any string.<br />
When the code reaches that line, Access just hangs, no error message. I have to go into task manager to close Access down.<br />
&nbsp;I precede that line with:<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.ComplaintID.SetFocus<br />
I have tried other forms of the line such as:<br />
&nbsp; &nbsp; &nbsp; &nbsp; Forms.frmPt.ComplaintID.Te<wbr />xt = strFilter<br />
&nbsp; &nbsp; &nbsp; &nbsp; frmPt!ComplaintID.Text = strFilter<br />
&nbsp; &nbsp; &nbsp; &nbsp; ComplaintID.Text = strFilter<br />
&nbsp;with the same result.<br />
&nbsp;I have used<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Me.ComplaintID.Text = <br />
&nbsp;in other areas of the object module without problem.<br />
&nbsp;Any ideas what is going on?
</div>
</div>


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?

VBA Line causes Access to hang up.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.