Requery a Sb-Sub Form

P

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
 
C

Cyberwolf

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

frmtblOutputALRP_Detail.Requery
 
P

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top