Me.requery
http://office.microsoft.com/en-us/access-help/refresh-or-requery-data-HA
010256400.aspx
Bob Peterson
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Thomas
Sent: Tuesday, July 24, 2012 2:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] updating records
How can I update the record(s) to include a time-stamp field updated and
the userid when the record is updated via the form?
The form allows for edit and filter only. After the record(s) are
updated on the form, the updated information does not reflect on the on
the form immediately. I notice the updated information is displayed
after I close and reopen the form. So I know the affected rows are
updated by Access.
Is there any way to force the update to be displayed immediately on the
form after the rows are being updated?
If I want to include some additional information, such as the time-stamp
at the time of the update and the userid etc, as part of the record
update, what event will allow me to included this before Access update
the row(s) ?
Regards,
Thomas
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar