Unanswered: Visual Basic code help - multi field search
I found the code below and tweaked it to work with my database to use an unbound text box to search the 'LeadNumber' field. What I've been unable to do is tweak it further (tried using 'OR' followed by code for additional field name) to search the "LeadNumber" and second field called "AgentLeadNumber".
Any help will be greatly appreciated!
Private Sub leadsearch_AfterUpdate()
Dim rec As Recordset
Set rec = Me.RecordsetClone
rec.FindFirst "LeadNumber like '*" & leadsearch & "*'"