Missus_Nat
Registered User.
- Local time
- Today, 03:12
- Joined
- Sep 14, 2012
- Messages
- 22
Hello All!
I want to put an 'After Update' code (or possibly an 'On Change' code) on my Text Boxes so that changing the auto-filled data in the Form updates the record, rather than creating a new record.
Here is the After Update code I am using in my Combo Box to produce the auto-fill data:
Private Sub Course_AfterUpdate()
Me.[Date of Training] = Me.Course.Column(2)
Me.Location = Me.Course.Column(3)
Me.Instructor = Me.Course.Column(1)
Me.Grade = Me.Course.Column(4)
Me.Certificate = Me.Course.Column(6)
End Sub
This part works great, but when I change the displayed data (ex. change the date from 2010 to 2012), it creates a new record in the Table. In this example I want it to replace 2010 with 2012 in the existing Record.
Any help would be aweso-rific!!
I want to put an 'After Update' code (or possibly an 'On Change' code) on my Text Boxes so that changing the auto-filled data in the Form updates the record, rather than creating a new record.
Here is the After Update code I am using in my Combo Box to produce the auto-fill data:
Private Sub Course_AfterUpdate()
Me.[Date of Training] = Me.Course.Column(2)
Me.Location = Me.Course.Column(3)
Me.Instructor = Me.Course.Column(1)
Me.Grade = Me.Course.Column(4)
Me.Certificate = Me.Course.Column(6)
End Sub
This part works great, but when I change the displayed data (ex. change the date from 2010 to 2012), it creates a new record in the Table. In this example I want it to replace 2010 with 2012 in the existing Record.
Any help would be aweso-rific!!