Hello, I am trying to create a form with a sub form that filters table results based on what is selected in a combo box. I have been fighting with this for a bit and I after changing some things around I am finally stuck with a Syntax error 3464. Why would I be getting this? The code I am using is below. Thanks!
Private Sub comboTower_AfterUpdate()
Dim myTower As String
myTower = "Select * from BuildingBlocks where ([Tower] = " & Me.comboTower & ")"
Me.BuildingBlocksSubform.Form.RecordSource = myTower
Me.BuildingBlocksSubform.Form.Requery
End Sub