View Single Post
  #9 (permalink)  
Old April 10th, 2004, 07:44 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Select Case aposit
    Case "Sr. Resident Engineer"
        txtValue = "1"
        Case "Resident Engineer"
        txtValue = 2
'insert the remaining values here
End Select

Or you can still try to use the IIf function and if you ever want to add another value, you will have a nightmare to make sure that the code will work. And the IIf statement will slow down your app.

Make sure that you have a text box that has the name txtValue (I should not have to say that)



Sal
Reply With Quote