Re: Can't get subform on tab control to requery

Gillian,
I think you are 99% of the way there.
In your main form both subforms have are controls and have names. Lets
call them sfLive and sfDead for this.
On after update event for the live form try
me.requery
me.parent.sfDead.form.requery
Now remember that after_update only happens when you leave the record
you are editing. In order to facilitate this easily you can add a save
button for the user that has the code 'docmd.runcommand
accmdsaverecord'
HTH

.

Relevant Pages

  • Re: Form instance using variable for name
    ... forms have subforms, which I recursively open. ... but the controls can't be accessed when the form isn't open. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Lock all field except one
    ... > To unlock, ... > If there are any subforms, the code calls itself to handle them also. ... > flexibility to leave certain controls unlocked, ... > Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.forms)
  • Re: Multiple date parameters
    ... two new controls, NEITHER of which connect to any table fields. ... My main form is built off of MonthlyAll. ... The main form contains two subforms: ... How can I simplify this so that I only enter the date criteria one time ...
    (microsoft.public.access.forms)
  • Re: Nested Subform References
    ... Add the ".Form" bit to each reference, ... It would be possible to write a routine that loops through all forms in the ... their subforms as well. ... You do realise that this locks even unbound controls? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant prevent updates and allow new records on form/subform/su
    ... be to set Allow Edits to No for the form and subforms by default, ... Allen Browne - Microsoft MVP. ... If you set AllowEdits to No, you can't edit in any of the controls on ... I set the Allow Edits ...
    (microsoft.public.access.forms)