Recordset doesn't refelct 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
 
thanks
But how can see what is the value. I need to update the parent form based
the value ( which I can't see it until i moved to the next record)
 
ok. I got by setting the on current events.
so i can see the change after it was updated
 
A value is not committed to the database until you SAVE the record it
which can occur one of several ways.

1. Move to new record
2. Select SAVE/SAVE RECORD from the menu
3. CTRL+SHIFT (saves the records)
4. Click a button that calls code which saves the record.

David H
 
If you mean changing a value on the PARENT form (eg STATUS). Just
reference the control on the subform as in

Forms![formName]![subformName].form![controlName]

and use the AfterUpdate event for the control (fires when you exit the
field) in question or the AfterUpdate event for the subform which fires
after the record is SAVEd.
 
Back
Top