Hi,
Regarding the subject; The row source of sub-form is controlled by the after update of main form CBo and the below code works fantastic but bit slower and shall press Esc while changing the item in Cbo at main form.
Is there any better and faster solution?
Code:
Private Sub CboEquipment_AfterUpdate()
Dim strSQL As String
strSQL = "SELECT ItemID, ItemCode, TechnicalName, InstalledQty " _
& "FROM TblItemMaster " _
& "WHERE EquID = " & Me.CboEquipment
Me.SFrmSPChange.Form.CboSParts.RowSource = strSQL
End Sub