VBA Access question - Best method to search
Posted on 2013-06-12
Not all clients will have an system Id associated to their name. System Id is an generated number based off an external web database. User entered the system Id is person is in web database. I'm working with bound forms.
I have a field that finds all client information based off system ID using following code below:
Dim rs As DAO.Recordset
If Not IsNull(Me.cbotest) Then
'Save before move.
If Me.Dirty Then
Me.Dirty = False
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[strClientId] = '" & Me.cbotest & "'"
If rs.NoMatch Then
MsgBox "Client Not found: filtered?"
'Display the found record in the form.
Me.Bookmark = rs.Bookmark
Set rs = Nothing
What would be the best method to search for a client? Drill down search based off Last name to first name? One combo box that contains full Name? Database is more of a side work project, so I'm not a full developer. Looking for best ideas or approaches.