Synchronizing 2 forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've searched this forum and tried several of the suggestions here to fix
this problem, but I still can't make it work. Hoping someone can help.

I have a main form (fClientFile) with several tabbed forms. One is fClient.
On fClient I have a subform called fIndustryView. I also have a command
button which opens another form called fIndustryAdd. When I click on the
command button to open fIndustryAdd, I can add/change/delete industry types.
I want these changes to be seen immediately in the subform fIndustryView.

Currently, when I change an existing record in fIndustryAdd, the change
reflects immediately in fIndustryView. I was able to accomplish this much by
having the event procedure:

Private Sub IndustryID_AfterUpdate()
Me.Dirty = False
End Sub

on the "after update" for the control IndustryID on the form fIndustryAdd.
However, additions or deletions are not reflected until I close fClientFile
and then reopen.

I've tried various suggestions I've found in this forum, but either they
don't solve my problem or I don't understand how to apply them. I am new to
Visual Basic, so any help should be explained at a very basic level.

Thanks in advance for any help anyone can give.
 
Thanks for the reply. I don't think this helps me though because only
fIndustryView is a subform linked to fClient. fIndustryAdd opens in a
separate window, so is not linked through a master/child relationship.
Perhaps I missed some code in reviewing the sample?
 
Back
Top