recordset doesn't reflect changes

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

Guest

Hi
I have Continuous Forms defined as a subform.
When i do a change to a field i see the change on screen .
BUT the recordset is not reflecting the change until i change another
record. and the new record change will be reflected only after another record
was change


please help
 
Hi
I have Continuous Forms defined as a subform.
When i do a change to a field i see the change on screen .
BUT the recordset is not reflecting the change until i change another
record. and the new record change will be reflected only after another record
was change
Click to expand...

Actually, there's a subtle difference: the record is saved, not after
you *change* another record, but after you *set the focus* to another
record (or move off the subform onto the mainform, or close the form,
or various other actions).

If you wish to force an immediate save of a record, pick some
appropriate event (such as the AfterUpdate event of some control on
the subform), and write code like

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


John W. Vinson[MVP]
 
Back
Top