Code:
If Me.Text45 = "Noonan Syndrome" Or Me.Text45 = "Marfan Disorder" And Me.Text45 = "" Then
Me.Text61 = DLookup("[Kit]", "[tblExtraction]", "[Inuse] = -1")
Me.Text63 = DLookup("[Lot]", "[tblExtraction]", "[Inuse] = -1")
Me.Text65 = DLookup("[QC]", "[tblExtraction]", "[Inuse] = -1")
Me.Text67 = DLookup("[Exp]", "[tblExtraction]", "[Inuse] = -1")
Me.Text92 = DLookup("[Kit]", "[tblBarcode]", "[Inuse] = -1")
Me.Text94 = DLookup("[Lot]", "[tblBarcode]", "[Inuse] = -1")
Me.Text96 = DLookup("[QC]", "[tblBarcode]", "[Inuse] = -1")
Me.Text98 = DLookup("[Exp]", "[tblBarcode]", "[Inuse] = -1")
I have this code as an after update, however it only seems to update if Noonan Syndrome is selected. I need it to change if the other criteria is selected as well. Thanks.