You can simplify it like this, plus be able to see how the txtkeywords string looks with debug.print:
Define sSearch as the comparison string including the single quotes and asterisks.
Code:
Private Sub Command433_Click()
Dim sSearch As String
Dim SQL As String
sSearch = "'*" & Me.txtKeywords & "*'"
'debug.print sSearch
SQL = "SELECT tblOrderNotifications.CreatedOn, tblOrderDetails.WBS, tblOrderNotifications.Notification, tblOrderDetails.Revision, tblOrderDetails.OrderType, tblOrderDetails.OrderNum, tblOrderDetails.Sortfield, tblOrderNotifications.CreatedBy, tblOrderStatus.AssignUsername, tblOrderDetails.PlannerGroup, tblObjectStatus.Status, tblObjectPriority.Descripton, tblProjectStatus.DateClosed, tblOrderStatus.Project FROM tblOrderNotifications LEFT JOIN (tblObjectStatus RIGHT JOIN (tblObjectPriority RIGHT JOIN (tblProjectStatus RIGHT JOIN (tblOrderDetails LEFT JOIN tblOrderStatus ON tblOrderDetails.OrderNum = tblOrderStatus.OrderNum) ON tblProjectStatus.ProjectNum = tblOrderStatus.Project) ON tblObjectPriority.PrioID = tblOrderStatus.PRIOID) ON tblObjectStatus.SID = tblOrderStatus.SID) ON tblOrderNotifications.Notification = tblOrderDetails.Notification " _
& "WHERE (((tblProjectStatus.DateClosed) Is Null)) " _
& "Or (tblOrderDetails.OrderNum) LIKE " & sSearch _
& " Or (tblOrderDetails.WBS) LIKE " & sSearch _
& " Or (tblOrderDetails.Sortfield) LIKE " & sSearch _
& " Or (tblObjectStatus.Status) LIKE " & sSearch _
& " Or (tblOrderNotifications.Notification) LIKE " & sSearch _
& " Or (tblOrderDetails.Revision) LIKE " & sSearch _
& " Or (tblOrderDetails.OrderType) LIKE " & sSearch _
& " Or (tblOrderNotifications.CreatedBy) LIKE " & sSearch _
& " Or (tblOrderDetails.PlannerGroup) LIKE " & sSearch _
& " Or (tblOrderStatus.AssignUsername) LIKE " & sSearch _
& " Order BY tblOrderNotifications.CreatedOn DESC"
Me.RecordSource = SQL
Me.Requery
End Sub