<div>
Try this in the Form Load event<br />
<br />
Private Sub Form_Load()<br />
&nbsp;<b> &nbsp; Me.ReCalc &nbsp;</b><br />
End Sub<br />
<br />
mx<br />
<br />

</div>


Try this in the Form Load event

Private Sub Form_Load()
    Me.ReCalc  
End Sub

mx



<div>
<div class="content wysiwyg-content">
I have a main form with a subform that has a combo box in the subform. &nbsp;A few of the fileds reference the combo box &nbsp;- - - &nbsp;=[ProductSupPtsID].[column<wbr />](2).<br />
<br />
When I open the form the data in the fields with the references do not show up. &nbsp;If I manually click on the field it will show up.<br />
<br />
Is there a way to get these fields to refresh so they will show up when the form opens?<br />
<br />
Thanks for your help.
</div>
</div>


I have a main form with a subform that has a combo box in the subform.  A few of the fileds reference the combo box  - - -  =[ProductSupPtsID].[column](2).

When I open the form the data in the fields with the references do not show up.  If I manually click on the field it will show up.

Is there a way to get these fields to refresh so they will show up when the form opens?

Thanks for your help.

ms access .[Column] refresh in subform datasheet

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.