Your DoCmd.Close ... syntax doesn't save the data, is saves any Form Design
work you've done. If your form is bound, then Access should save that data
for you (there can be a slight delay in writing to the tables). You
shouldn't have to close and reopen Access in order to see your new data; it
should be available as soon as it's saved to the table.
Note that you can force data to be saved by issuing this command:
If Me.Dirty then Me.Dirty = False
If I have misunderstood your question, please clarify.
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Smash forehead on keyboard to continue ... "
"ARobi" <ar***@nospam.com> wrote in message
news:40**************@nospam.com...
I edit data from a form by using docmd.close acform, formname,
acsaveyes. The form closes properly and returns the control to the
father form as it should be.
The problem is that when from the father form I try to access the new
data from the table which was related to the closed (child) form, for
example using dlookup(), I can't retrieve new data. I have to close all
the forms and restart the program to be able to read the new data from
the table.
Somehow, data are not written to the table and are probably hanging
somewhere in a buffer. How can I save data to the table so it can be
used right away without closing the application?
Tks