Hi everybody!
I have a main form (unbound) with a comboxbox.
In the main form I have a subform which will bring values form a table realted to the value selected in the combox.
How do I populate the subform since I receive errors on this line:
Private Sub MainCombo_AfterUpdate()
Dim strSQL As String
strSQL = "SELECT * FROM Employee WHERE AID = " & _
Me!AID.Column(0)
Forms![frmMainForm]![frmSubForm].RowSource = strSQL
'this is the error line
End Sub
Thanks a lot,
TMRO
I have a main form (unbound) with a comboxbox.
In the main form I have a subform which will bring values form a table realted to the value selected in the combox.
How do I populate the subform since I receive errors on this line:
Private Sub MainCombo_AfterUpdate()
Dim strSQL As String
strSQL = "SELECT * FROM Employee WHERE AID = " & _
Me!AID.Column(0)
Forms![frmMainForm]![frmSubForm].RowSource = strSQL
'this is the error line
End Sub
Thanks a lot,
TMRO