well my subject explain it all. i tried attempting this but it wouldn't work. anyone can help.

Try putting the criteria for the record you want to move to into the docmd.openform line on the command button eg.

DoCmd.OpenForm "formname", , , "criteria"

where formname is the name of the form to open and criteria would be for example
"surname = 'Green'"

Cant you use the wizard to do this? I have tons of buttons on my forms and i link them right to any other form or report that i want to. Try using the wizard it will probably help you the most