how do you get one form with a command button to open another form w/ a specific rec.

[gino]

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

 

[nick]

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'"

 

[tracey75]

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