Form change when record added

[luis_a_roman via AccessMonster.com]

I have a form that enable me to add a record with several fields. When I add
the last record or when the last field is entered the record in the form
change.

Is there anyway that I can refresh the form with the record added? Could I
modified the record RowSource with the appropriate SQL statement? Or should I
execute another Docmd.OpenForm with a filter to get the record added?

Want options to understand how does it work? Specially, want to understand
the impact that the RowSource has when modified in a form?

Thank you for guidance and collaboration with this question.

Luis

 

[Larry Daugherty]

Something that might help is to add a command button to "Save Record".
In the Click event of that command button put the line
me.dirty = false

That might confuse your users who might then assume that records won't
be saved unless an explicit "save" command is given.

The question arises: why do you want to continue to edit a record
after you have just saved it?

Another method that works is simply to use the navigation buttons at
the bottom of the window.

One other thing that could cause problems would be the form
properties.

HTH