morpheusdreams
MIS
Code:
Private Sub dd_Name_Change()
Dim strSQL As String
strSQL = "UPDATE tblVar SET [AgentID]=" & Form_frm_EditAgent.dd_Name.Value & ";"
DoCmd.RunSQL strSQL
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
End Sub
What the above should be doing is when the dropdown changes sending its value to the variable table.
The form should then refresh, thus refreshing the data in the subform which is linked to a query based on the value updated in the variable field.