none
a calculated field in Access 2007 RRS feed

  • Question

  • 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