VBA Update Subform

[natural]

Good Day, I was currently browsing on ways to update records within a form to a subform. and noted the following article by Alan Brown on how to make use of the

With Me.[NameOfYourSubfo rmControlHere].Form.Recordset Clone
.AddNew
!SomeControl = SomeValue
!AnotherContorl = AnotherValue
'etc.
.Update
End With

http://www.thescripts. com/forum/thread190259.ht ml

I am currently usting the above menioned as folllows and works perfect to update my subform

Private Sub cmdAddSkills_Click()
With Me.[SkillsList].Form.RecordsetClone
.AddNew
!PersonID = MeID
!SkillID = Me.AddSkills
.Update
End With
End Sub

It does however not seem to actually updat the records If i go into another form to view the added data it is still the same data as before. Does the above meniotioned actually append the data to the records.
Or am i missing something.

[Scott Price]

Did you copy and paste your code in? If not, is line 4 a typo?

!PersonID = MeID

If you are trying to refer to a control on your form named ID, the correct code is Me.ID or Me!ID. What you have (assuming you've not declared this as a variable and populated it elsewhere) is an implicitly declared variable named MeID that contains nothing, therefore your PersonID will be populated with nothing.

A VERY good coding practice is to require explicit declaration of variables by enabling the Option Explicit in your editor window by clicking on Tools>Options>E ditor and check the box Require Variable Declaration (and typing it into modules that don't have it). This just means that you cannot misspell something in your code, because when you compile, Access will check and give a compile error if the variable has not been declared in the proper way.

Otherwise you can type anything in you want (within some limits of course) and Access will assume that you are declaring a variable and will give it the type of Variant. This can wreak havoc in your code!

Regards,
Scott

[natural]

Hi Scott..

Thank you very much for your help. Working perfectly..

Regards
Susan

[Scott Price]

Hi Scott..

Thank you very much for your help. Working perfectly..

Regards
Susan

Glad to hear it's working!

Regards,
Scott