The actual field name is fk_Ok2
The original code on this topic read:
SB2Key2Update
So I added "Update" to the field name. When I remove, the code runs, but no updates actually happen.
Thanks.
amywolfie
Last Activity: Feb 23 '12, 09:50 PM
Joined: Feb 21 '12
Location:
-
Here is my code:
...Code:Private Sub PrimaryDataBatchID_AfterUpdate() On Error GoTo Error_Handler: 'Appends DataBatchID to OK_DataBatchID since usually the same -- AW Dim rst2 As Recordset Dim rst1 As Recordset Set rst2 = Forms![frmMain]![subfrm_tblOverkeyDataBatchID].Form.RecordsetClone Set rst1 = Forms![frmMain]![subfrmgd_tblPrimaryDataBatch].Form.RecordsetClone 'find the
Leave a comment:
-
Yes, sorry. The original topic is at:
http://bytes.com/topic/access/answer...ubform-another...Leave a comment:
-
Copy from 1 subform to another
This is an existing topic. A good solution is given, but one line of code doesn't work:
rst2!Field2Upda te = Me.SF1Field
It has to do with Update.
What is the proper VBA syntax to update a field as shown above?
Thanks!
No activity results to display
Leave a comment: