User Form VBA - Complie Error in cmd button

OK, this time I hope this is the last time today I have to keep posting and I appreciate all the help I've been receiving but again I am new at VBA and I coded a cmd button to go to previous record and I keep getting an compile error -Syntax error and the top line is highlighted.

Please Login or Register  to view this content.

Any help please

Thank you I did it and I received no error but the command button does nothing I keep pressing the button and the records do not move and no error comes up.

Please Login or Register  to view this content.

[/CODE]

Forgive me for I am a newbie with VBA but when you "not initialized" What do you mean?

Well here is another newbie question how do I assigned a value to it ?

OK, So I took the code above but i get errors and I think its becasue I already have an Update and next record code . I also did change wording in my code which is below and now it runs and no error but when I go to press the command button it does nothing??

Please Login or Register  to view this content.

Hmmmmmm

I am trying to make a command button to go to previous record in my user form and when I run the form it goes but when I go to hit the command button with the code below it does nothing not sure what I am doing wrong?

Please Login or Register  to view this content.

I tried it and when I go to run the command button I just get a "Now you are in the header row" and the form does nothing.

Not sure if it matters but I have a second command button which is Next Record and t goes to the next record in my user form it is below
This code works for next record

Please Login or Register  to view this content.

This code does not work trying to go to PREVIOUS record

Please Login or Register  to view this content.

I am trying to get the second code to work?? Please

I did but I think I know what I did wrong I put the whole code in together and not separate also I kept my other next record code as well so I am not sure but I am going to try it again I have two command buttons one "Next " and other coded "Previous" So I am assuming taking the code from post #9 and separating it???? going to try it now

I am a little confuse on how to put the code below in ?? I already have an " next record" command button that works and I also have an "initialize form code as well" With the code below do I separate it and replace my codes I have now?

Please Login or Register  to view this content.

I was just about to write back I did it and it work but now there another problem my update command button not updating records and all my text boxes are pulling the headers as well records from my worksheet. I just now need to fix my update command button.
And again you're awesome!!! I appreciate the help

I just realzie I need to put my code back for updating my records I will see if it works once I put it in.

Thank you again YasserKhalil!! Again like always you are a genius!!!