I am trying to filter my table with combo box(https://www.youtube.com/watch?v=8N1hRBdsI1s) like this tutorial but i am having trouble with the Code Builder.
Private Sub cboCustomerType_AfterUpdate() Dim myCustomerSummary As String myCustomerSummary = "Select * from Customer where ([Customer_Type] = '" & Me.cboCustomerType & "')" Me.CustomerSummarySubform.Form.RecordSource = myTransSummary Me.CustomerSummarySubform.Form.Requery End Sub
which retus the error:
The record source 'Select * from CustomerSummary where ([Customer_Type = 'Buisness'] specified on this form or report does not exist.
If anyone can help that would be much appreciated