Well, I am getting closer, but not there yet. Now the button doesn't error, it closes, other form opens, but it opens to the wrong record. Here is what I have now:
Code:
Private Sub cmdOpenfrmIndividualDataEdit_Click()
Dim rs As Object
Dim lngBookmark As String
'set a variable to the current record
lngBookmark = Me.EmployeeID
'open the new form
DoCmd.OpenForm "frmIndividualDataEdit"
'take it to the selected record
Set rs = Forms!frmIndividualDataEdit.RecordsetClone
rs.FindFirst "EmployeeID = '" & lngBookmark & "'"
Forms!frmIndividualDataEdit.Bookmark = rs.Bookmark
Set rs = Nothing
DoCmd.Close acForm, "frmSelectIndividual"
End Sub
Might just need to walk away from it for the day and revisit it tomorrow.