Another Access 2007 Search Question
Posted on 2011-09-08
I have the following coding that will find Alias1, Alias2, Alias3, Alias4, and Alias5. What If I have two or more records with the same Alias. I need some coding to find records with the same Alias on any of the Alias1, Alis2, Alis3, Alias4, and Alias5.
I need a Find Next Button to find these records. How can the VBA cdoing be written to do this?
Private Sub Command9_Click()
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst "[Alias1] = '" & Me.Text10 & "' Or [Alias2] = '" & Me.Text10 & "' Or [Alias3] = '" & Me.Text10 & "' Or [Alias4] = '" & Me.Text10 & "' OR [Alias5] = '" & Me.Text10 & "'"
If rs.NoMatch = True Then
MsgBox "There are No Records Found for this Alias Name. Please Try Again"
Me.Bookmark = rs.Bookmark
Any help is appreciated.