I'm having trouble setting a filter using the datalink control. I set the filter to but all the records are still apearing. I looked in the documentation and the samples but have not found an example using filtering or the datalink control. I have a dataset called PicsDS. The datalink's source is set to PicsDS.Pictures. The binding navigator is set to the datalink. I set the filter to:
Property CID() As Integer
Get
Return currentCust
End Get
Set(ByVal value As Integer)
loading = True
currentCust = value
Me.DataLink1.Filter = " CustID = " & CID()
End Set
End Property
where CID is the customer ID I'm trying to filter by. But even when I set the filter, all the records are still visible. Please help. I'm going insane.