Hi all,
Brand new to VBA here, so I'm in need of some assistance!
I have a database where you input one number, it looks up the number from a table, then spits out another number associated in the record (like vlookup). For the first value, I used an unbound combo box that has an invisible column holding the second value.
This is the code I used for this:
Private Sub txtPOTSku_Click()
Me.txtPotSku = Me.cboStockSku.Column(1)
End Sub
Now I'd like to incorporate some code that spits out "N.O.L" for the second value if it can't find the first value in the table. I hope this makes sense!
Thanks in advance,
Nicole
Brand new to VBA here, so I'm in need of some assistance!
I have a database where you input one number, it looks up the number from a table, then spits out another number associated in the record (like vlookup). For the first value, I used an unbound combo box that has an invisible column holding the second value.
This is the code I used for this:
Private Sub txtPOTSku_Click()
Me.txtPotSku = Me.cboStockSku.Column(1)
End Sub
Now I'd like to incorporate some code that spits out "N.O.L" for the second value if it can't find the first value in the table. I hope this makes sense!
Thanks in advance,
Nicole