Though the code is probably very close, I was not able to get this working in an application I am building using two unbound forms. When I click the button now nothing happens. I have one form (frmSurveyResults) that will open to another (frmSurveyResultsPg2) to complete a record in a table. Initially I need this to open to a new form. However, in this case I need the form to open to an existing table field called "SurveyID". The following is what I have from your example:
Private Sub Command402_Click()
DoCmd.OpenForm "frmSurveyResultsPg2", , , "SurveyID=" & Me.SurveyID
Your help is greatly appreciated!