Requery issue : Application closes on form.requery....

[surya]

Hi,
This is the line where my application (a converted application from ms
access 97 to 2003) closes down.

Me.Parent![e2].Requery

In the command click event, where e2 is the sub form.

Strangely, it works fine in Access 97 version.

Can somebody help me.

Thanks in advance.

 

[ruralguy via AccessMonster.com]

Hmmm...
Try Me.Parent![e2].FORM.Requery

Hi,
This is the line where my application (a converted application from ms
access 97 to 2003) closes down.

Me.Parent![e2].Requery

In the command click event, where e2 is the sub form.

Strangely, it works fine in Access 97 version.

Can somebody help me.

Thanks in advance.

 

[surya]

Hi RG,

Thank you for the update, I tried it, but it didn't work.
Please suggest.

regards,
Surya

--
Suryanarayana Bollapragada

Hmmm...
Try Me.Parent![e2].FORM.Requery

Hi,
This is the line where my application (a converted application from ms
access 97 to 2003) closes down.

Me.Parent![e2].Requery

In the command click event, where e2 is the sub form.

Strangely, it works fine in Access 97 version.

Can somebody help me.

Thanks in advance.

 

[ruralguy via AccessMonster.com]

Are you getting an error? If so, what is it? I take it [e2] is another
SubForm of your Parent form other than the SubForm you are executing from.

Hi RG,

Thank you for the update, I tried it, but it didn't work.
Please suggest.

regards,
Surya

Hmmm...
Try Me.Parent![e2].FORM.Requery

[quoted text clipped - 12 lines]