sfrm Recall after Source tbl UpDated

[bepaling]

Hey Team,

Some background: I have frmWorkDirective with sfrmMaterialsList. User inputs all information for the WorkDirective, then inputs all Materials used on MaterialList.

Problem is, with new parts coming in as we expand, they aren't all in the Source Table: tblMaterials. So, I created a new Form to create the New Materials (frmNewMaterial). On frmWorkDirective I have a Command Button that will open frmNewMaterial & automatically go to New Record. The User can input the New Material, Save the Record & Close the Form.

However, when I go back to sfrmMaterialsList, the New Material just created doesn't show up. Any thoughts/ideas on how to rectify this problem?

Cheers

 

[PHV]

Have you tried to Requery sfrmMaterialsList ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

the New Material just created doesn't show up
Where ? A combo ?
Try to Requery it.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bepaling]

Thanks all. I realized that I was looking for the display information in the wrong spot. But, for those that are interested, I did manage to get it to ReQuery using the following Code:

Forms!frmWorkDirective!sfrmMaterialsList.Requery