MainForm SubForm Requery from Third Form

[Ray Todd Jr]

I have the following:

frmMAIN w/subform of subDEFENDANTS

frmNEWPROPERTY w/subform subNEWDEFENDANTS

When I enter a new property on the frmNEWPROPERTY form and close that form,
I can then go look at the record on the frmMAIN. However, unless I close and
reopen the database, the defendantnames (cboDEFENDANTSNAMEID) do not show up
in the newly entered property.

I have tried the following attempts at requerying the data and have failed
with

Run-Time Error 438 Object Doesn't Support this Property or Method.

I put the following lines of code (not at the same time) in the after update
event of the subNEWDEFENDANTS form of the frmNEWPROPERTY form.

forms!frmMAIN!subDEFENDANTS!DefendantsNameID.Requery

forms!frmMAIN.requery

Any suggestions would be appreciated.

Thanks,

Ray.

 

[Allen Browne]

Try with the .Form bit:
forms!frmMAIN!subDEFENDANTS.Form!DefendantsNameID.Requery

Explanation in:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

 

[Ray Todd Jr]

Thanks Allen, that did it....

Try with the .Form bit:
forms!frmMAIN!subDEFENDANTS.Form!DefendantsNameID.Requery

Explanation in:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html