Access 2007 Search Question with VBA Coding
Posted on 2011-09-06
I have the following code wrtten in VBA to fnd the Alias1 name. How can I write the coding to
allow the computer to find an Alias2, Alias3, Alias4, and Alias5 if a entry is made in the TextBox for Alias2 or Alias3, Alias4, or Alias5 and the Find button is selected?
Private Sub Command9_Click()
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst "[Alias1] = '" & 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.