Try this:
Private Sub Save_Click()
On Error GoTo Err_Save_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70
Exit_Save_Click:
Exit Sub
Err_Save_Click:
MsgBox Err.Description
Resume Exit_Save_Click
End Sub
Bernadette D. Meunier
Information Technology
A.W.Hastings & Co.
2 Pearson Way
Enfield, Ct 06082
www.awhastings.com
Phone: 800-394-2784 ext. 2244
Fax: 800-966-2732
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Tobi Hoffman
Sent: Monday, June 13, 2005 1:16 PM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] force update form
Off the top of my head, I believe what you need is:
DoCmd.RunCommand acCmdSaveRecord
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of v_f_dauber
Sent: Monday, June 13, 2005 11:01 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] force update form
Hi All,
got a problem with a form. i have some code that works fine when going
to a new record set, however when some information is edited the codew
ill not recognise the information until i either open and close the
form or go ahead one record and come back to that record (use record
selector buttons).
is there any way that i can place a button on that form so that it will
force that the record to be updated as soon as the button is pressed?
any help would be very much appreciated.
cheers
volks
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
