recordset doesn't reflect changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wasseem - 03 Oct 2005 19:01 GMT

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

Reply to this Message

John Vinson - 04 Oct 2005 06:13 GMT

>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

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]

Reply to this Message