var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Code to Save Record
Help please for code that will save a data record in a form to the Table on Event BeforeInsert. I want the code to perform the same function as Save Record in the Record Menu.
I don' think your question is too clear. The before update event runs just before a record is saved so the process is allready underway.
Reply to AZ KC re: Code to Save Record
BeforeInsert occurs when you type the first character in a new record and before the record is added to the database.
What I'm trying to accomplish is for the record to save to the table as soon as a user begins entering date into a form.
Hope this helps - Thanks
this is the code behind the menu item you speak of
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Dale Houston, TX
why not have a [AddNew] command button that does the work and preps the next blank record (CustomerName must allow zero length):
Private Sub cmsAddNew_Click()
On Error GoTo Err_cmsAddNew_Click
Me.CustomerName = ""