After Update Code

awake2424

Registered User.
Local time
Today, 15:34
Joined
Oct 31, 2007
Messages
479
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.
 
How could something be both "Marfan Disorder" AND ""? ;)
 
I realized that after I posted, Thank you for your help.
 
No problem. If you're testing a different textbox, make sure to clarify the logic of the And's & Or's with parentheses.
 

Users who are viewing this thread

Back
Top Bottom