Form/Subform update problems

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi all,

I have a query about forms/subforms in Acc97. I have developed a 'master'
form that has a web style menu interface down the left hand side. The
'masters' form's record source is tblMember (PK - mbrID). The db tracks
varying training and personnel issues and as a result I programatically
change the SourceObject of a subform to the varying underlying tables.

The problem I have is that I am having trouble updating a subform that has
the same record source as the 'master' form. The subform has no navigation
buttons as the intention is to use the main form. I can use the main form to
(for example) create a new member, however even though the ifo is saved to
the underlying table, the total number of records in the navigation bars is
incorrect. The only way that I can fix at the moment is to reload the
'master' form.

I would guess that the subform would have to indicate to the main form that
a new record is available and that it has to refresh its table source (?).
I intend to keep trying, however any help anybody could provide would be
fantastic,

Cheers
Rob
 
on the subform's AfterUpdate event, you could add code as

Me.Parent.Requery

note that on the main form the requery will take you back to the first
record in the dataset.

hth
 
Back
Top