Requery a Sb-Sub Form

[PGPianta]

Hi,

I have to perform a requery on a 2nd Level Subform the exists within a
subform of the main form. (Got that?) I am having trouble getting the
syntax right...any help would be appreciated...

Mainform: frmCASSMain
SubForm1: frmALRPSub
SubForm2: frmtblOutputALRP_Detail

I have tried many variations on the theme...

Forms!MainForm!Subform1.Form!SubForm2.Form.Requery

But it doesn't seem to recognise the SubForm2...

Many Thanks

 

[Guest]

Just try using the name of the 2nd subform sort of like this

frmtblOutputALRP_Detail.Requery

 

[PGPianta]

Thanks, but no luck! ;o(

 

[PGPianta]

O.k. No I;m embarressed, I hadn;t actually named the subform on the
main form the correct name...this is hy it couldn't be found in the
first place...thanks again for your help!