Hi Allen

Thanks for helping me along the way, I feel that I am very close to working
this out.

Is it possible to have the user enter a first or last name in a single
unbound textbox on a form and run a query that will pull up all records
matching either the first or last name entered?

This is what I have so far, it only works when the last name is entered.

VBA

Private Sub cmdFilter_Click()
Dim strWhere As String
If Not IsNull(Me.txtFilterMainName) Then
       strWhere = Me.txtFilterMainName
       strWhere = "([FirstName] Like ""*" & Me.txtFilterMainName & "*"") or "
   End If
   
   If Not IsNull(Me.txtFilterMainName) Then
       strWhere = Me.txtFilterMainName
       strWhere = "([LastName] Like ""*" & Me.txtFilterMainName & "*"") "
   End If
       Me.Filter = strWhere
       Me.FilterOn = True
End Sub

query SQL
SELECT qryRecordSource.StudentID, qryRecordSource.FirstName,
qryRecordSource.LastName, qryRecordSource.CurrentGrade
FROM qryRecordSource
GROUP BY qryRecordSource.StudentID, qryRecordSource.FirstName,
qryRecordSource.LastName, qryRecordSource.CurrentGrade
HAVING (((qryRecordSource.FirstName) Like "*" &
Forms!StudentReport!txtFilterMainName & "*") Or ((qryRecordSource.LastName)
Like "*" & Forms!StudentReport!txtFilterMainName & "*"));