Requerying SubForms

[cdacey]

Hi
Could anyone help me on on the correct syntax to requery a sub formB once I have updates Subform A. I would like to place code on the After update property of Subform A that requeries Subform B, and I am having difficulty.

Thanks Chris

 

[Rich]

Forms!MainFormName!SubFormName.Form.Requery

 

[cdacey]

Rich, I gave that a shot, but
I am still getting the same error message

" Can't find the field 'subfformname' referred to in your expression"

Any other thoughts
Thanks Chris

 

[KKilfoil]

You were supposed to substitute YOUR names for the form and subform where Rich said 'MainFormName' and 'SubFormName'!

 

[cdacey]

Thats just what I did.

main form name = Appointments
1st subform name = Apptpts
2nd sub form name = Apptdisp

I was trying to place code on the after update event on the apptpts subform that would requery the apptdisp subform.

I placed this code in the after update event on the Apptpts subformform:

Forms!Appointments!apptdisp.form.requery

Same error stating the application can't find the "field" labeled apptdisp ??? I also tried the same line using recordsetclone.requery instead of form.requery, still had the same problem.

This seems like it should be simple ?

 

[Rich]

It's the subform control name as it appears on the main form, not in the db window.