a calculated field in Access 2007

• Question

• 

  

  0

  Sign in to vote

  I have an easy calculating job on a form which does not work.  The same codeing works on Access 2003 but not in Access 2007.

  I have 3 controls: Dose, Neuroleptics (in a combo box ) and CPZE(total power of the medication)

  the coding is:

  Private Sub Neuroleptics_Click()

  if (Dose)<>("") and Neuroleptics.value=119 then

  cpze.value=[Neuroleptics_Dose]*13.33

  end if

  Since i have total 17 neuroleptics, the rest of the coding are basically very similar with this one. I am not sure what went wrong for above.

  I have also tried to use IIF statement, but since this is a multi-level statement, I do not know how to compose it.

  Please help!

  Thank you.

   

   

   

   

   

   

   

  Thursday, October 21, 2010 8:33 PM