ms access .[Column] refresh in subform datasheet

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.
johnmadiganAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Or maybe


Private Sub Form_Load()
    Me.ProductSupPtsID.Requery
    Me.ReCalc  
End Sub
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Try this in the Form Load event

Private Sub Form_Load()
    Me.ReCalc  
End Sub

mx

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.