I am new to MS Access and i am trying to implement search using combo box. I am getting an compile (Syntax error) and i would appreciate if someone could help me out. Below is what i did:
Code:Private Sub Combo275_AfterUpdate() Dim Product As String Product = "Select * from G/S Stuff Sent where {[Product Name] = " & Me.Combo275 & ") " Me.G/S Stuff Sent_subform1.Form.RecordSource = Product me.G/S Stuff Sent_subform1.Form_Requery End Sub