requery a control on a form pulled from subform

[Summer123]

how do you requery a control on a form pulled from subform?
this should be easy but i'm going crazy here...

i've tried but it doesnt work

Private Sub Form_AfterUpdate()
[Forms]![Project_Details]![subform].[Form]![Text119].Requery
End Sub

please help?:banghead:

 

[jdraw]

Have you tried?? (a guess at the moment)

[Forms]![Project_Details]![subform].[Form].Requery

subform is the name of the subform??

 

[Summer123]

just tried that and that didnt work.... i inherited this db so not sure how to do this but i do see a macro on the form on the "On Load" event and it has things that i dont understand. also when i close out of the form and go back in the memo field is update with the selection i have made...

 

[jdraw]

Is subform the actual name of the subform?

You mention macro - is really working with macros or is it vba? I know zip about macros.

 

[Summer123]

the name is something else, but i pasted incorrectly...though in the code i have it correct. yes the form has macro but i'm trying to just requery the form using VBA ... should i not mix the 2 then? also i dont know anything about MACROS either

 

[jdraw]

What does the requery statement look like now? Please post what you have tried.

Try

Me.frmSubForm.Requery

where frmSubForm is the name of the subform Control

 

[Summer123]

first of all thank you for assisting me on this!
yes I've tried the following
project list - main form
project detail - subform
text119 is the control source
[Forms]![Project List]![project detail].[Form]![Text119].Requery

also just tried me.text119.requery - that didnt work either, though i'd like to use the on load event but i cant as there is already a macro there so had to use afterupdate should i use some other event? .. so in the onload macro i tried using the macro requery and refresh commands but those didnt work either.