OK, here is what I have for code now.
Code:
Private Sub Keywordsearch_Click()
'this opens the "mpl" form based on the choice in the "keywordsearhc field"'
If IsNull(keywordsearchbox) = False Then
DoCmd.OpenForm "mpl", , , "[keyword]='" & Me.keywordsearchbox & "'"
'I need to figure out the error message stuff'
If Me.Recordset.NoMatch Then
Me!searchbox = Null
If Me.Recordset.NoMatch Then
MsgBox "Error.", vbOKOnly + vbInformation, "Error."
End If
End If
End If
End Sub
It works ok. I still need to figure out the error message stuff on it. My main issue now is that I need to put the selected record back in the main form. I can get it to close, I just need the selected record to transfer first.
Private Sub mplselect_Click()
DoCmd.Close acForm, "mpl", acSaveNo
End Sub
Any Ideas? Thanks