<div>
The problem is caused by refreshing the parent form.<br />
<br />
Are you sure you want to check Me.txtProduct1 for Null AFTER you use it?????
</div>


<div>
Yes, because I want the value to be 0 if I deleted the entry.
</div>


<div>
You could try Me.Parent.NameOfControl.Re<wbr />query. Maybe that would work without having to tab twice, I am honestly not sure.
</div>


<div>
<div class="content wysiwyg-content">
I have the following code in an AfterUpdate event of a number field on a subform. &nbsp;But after making an entry in the field I have to press the tab key twice to go to the next field as determined by the Tab Index. &nbsp;Why would this be happening? &nbsp;I really only want to tab one time.<br />
<br />
Note: There is a field on the parent form that is being recalculated as the entry has been made in the subform field, hence the Me.Parent.Refresh code line.<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29011316-1"><span>    Me.txtProduct1StockAddedValue = Nz(DLookup(&quot;[StockAddedValue]&quot;, &quot;tblProducts&quot;, &quot;[ProductID] = 12&quot;), 0) * Me.txtProduct1</span>
<span>    If IsNull(Me.txtProduct1) Then Me.txtProduct1StockAddedValue = 0</span>
<span>    Me.Parent.Refresh</span>
</code></pre>
</div>
</div>


I have the following code in an AfterUpdate event of a number field on a subform.  But after making an entry in the field I have to press the tab key twice to go to the next field as determined by the Tab Index.  Why would this be happening?  I really only want to tab one time.

Note: There is a field on the parent form that is being recalculated as the entry has been made in the subform field, hence the Me.Parent.Refresh code line.

(CODE)

Why having to press tab key twice?

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.