Search results

Thanks Paul for your help!

Hi Paul: I am using a button to do the field update. this is its content: Private Sub CopyStudentAddress_Click() Me.Refresh CurrentDb.Execute ("UPDATE Guardians SET Guardians.Address = Address_Students WHERE Guardians.ID = " & Me.ID) Me.Refresh End Sub the id field is autonumber. Thanks...

Thanks for helping, Paul. Here is the line: CurrentDb.Execute ("UPDATE Guardians SET Guardians.Address = Address_Students WHERE Guardians.ID = " & Me.ID) Mary

Thanks for replying, Paul. it worked well when i use runsql, but when i tried with currentdb.execute, it shows the following error "runtime error 3061, too few paramenters. expected 1". Thanks very much your help. It is appreciated. :) Mary

Hi: My name is Maricruz, i am new programming with vba and have issues understanding the syntax of DoCmd.RunSQL Update. This is the line DoCmd.RunSQL ("UPDATE Guardians SET Guardians.Address = Address_Students WHERE Guardians.ID = Id;") :confused: id is a field in the form. When I...