Okay, still chugging away and making progress. Figured out how to get the correct values to populate Fusion Protein:
Code:
SELECT qryCellAssays.FusionPartnerNameFROM qryCellAssays
WHERE (((qryCellAssays.KinaseName)=[forms]![frmAssayRequest].[cboKinase]) AND ((qryCellAssays.AlleleName)=[forms]![frmAssayRequest].[cboAllele]))
GROUP BY qryCellAssays.FusionPartnerName
ORDER BY qryCellAssays.FusionPartnerName;
But now I cannot figger out how to trigger two simultaneous "Requery" events of both kinase and allele combo boxes. Once I get that then I think I'll wrap up today's project.
And back again with the solution. Context (command order)/syntax is indeed everything:
Code:
Private Sub cboAllele_AfterUpdate()
Me.cboKinase.Requery
Me.cboFP.Requery
End Sub
One more combo box to go and then I shall rest (far more than seven days though ;-)