MainForm SubForm Requery from Third Form

  • Thread starter Thread starter Ray Todd Jr
  • Start date Start date
R

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.
 
Back
Top