Hello,
I would like to add a search bar on the top of my tabular form that will filter my list. Here is the code I have so far but it is giving me an Compile error: Method or data member not found
Private Sub Command433_Click()
Dim SQL As String
SQL = "SELECT tblOrderNotifications.CreatedOn, tblOrderDetails.WBS, tblOrderNotifications.Notification, tblOrderDetails.Revision, tblOrderDetails.OrderType, tblOrderDetails.OrderNum, tblOrderDetails.Sortfield, tblOrderNotifications.CreatedBy, tblOrderDetails.PlannerGroup, tblObjectStatus.Status, tblObjectPriority.Descripton FROM tblOrderNotifications LEFT JOIN (tblObjectStatus RIGHT JOIN (tblObjectPriority RIGHT JOIN (tblOrderDetails LEFT JOIN tblOrderStatus ON tblOrderDetails.OrderNum = tblOrderStatus.OrderNum) ON tblObjectPriority.PrioID = tblOrderStatus.PRIOID) ON tblObjectStatus.SID = tblOrderStatus.SID) ON tblOrderNotifications.Notification = tblOrderDetails.Notification" _
& "Where (OrderNum) LIKE '*" & Me.TxtKeywords & "*' " _
& "Order BY tblOrderDetails.[OrderNum]"
Me.frmOrderStatus.Form.RecordSource.SQL
Me.frmOrderStatus.Form.RecordSource.Requery
End Sub