Requery not working

[charlee63]

I have a field called R_Cost when the cost change I what to requery the subform.

Private Sub R_Cost_AfterUpdate()
Forms![Food Show - Review All]![Food Show subform]![Cost Review Subform - Review All].Form.Requery
End Sub


This is not working?

 

[xenou]

it looks like you have a subform in a subform? Hard to tell.
Also you are requerying after a control update whereas a requery will work on the form data as a whole. I'm not really sure if the data will even be committed if you do that. You really should requery after the form is updated (the entire record, not just one control).

Recommend you rethink what you are trying to do - the data you just updated in a control will be changed by definition. what are you requerying for?