hi all,
I need some help. I am not sure why or what is wrong with my code but, the second Currentdb.execute only workes if i click on the button twice. Can someone help me to point out what i am doing wrong or how to consolidate all these to one currentdb.execute?
Code:CurrentDb.Execute "UPDATE Project " _ & "SET [Project Status] = 'O&M Review' " _ & "Where [Project Number] = '" & Me.Project_Number & "';" CurrentDb.Execute "UPDATE Approve_Close " _ & "SET [PR-PL] = '" & Me.PRPL & "' ,[PR-PL_DATE] = NOW() " _ & "Where [Project Number] = '" & Me.Project_Number & "';" Me.Requery CurrentDb.Execute "INSERT INTO Estimates ([Project #]) VALUES ('" & Me.Project_Number & "')"