I am getting a runtime error in the code behind my combo box in the AfterUpdate Event Procedure.
This is my line of code:
Me.RecordSource = "select * from Join where GroupID = " & cboGroup
Join is my table name and GroupID is the number id of group/dept
I am however getting this error when I select a group/dept from the combo box cboGroup:
Runtime error 3131 Syntax error in from clause