Iif & Checkbox

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ilushn
    #1

    Iif & Checkbox

    I had this figured out a few days ago, then Access shut down and I
    lost everything & can't remember how I did it.

    I have a check box (ConsultationSk illsWorkshopFee ) with an unbound
    field (ConsultationSk illsWorkshopFee Charge) next to it. If the box is
    checked I want a default amount of $80 entered into the unbound field,
    which I can change if the person is receiving a discount. Otherwise,
    if the box is not checked I want the amount to be $0. Can some tell me
    how I should be doing this, I'm at wits end. I keep thinking I should
    have the Default value be:
    Iif(Consultatio nSkillsWorkshop Fee)=True,"80", "0" - but when I put this
    in nothing happens... what's going on?

    Thanks!
    Tags: None
    • WindAndWaves
      #2
      Re: Iif & Checkbox

      you need to update the ConsultationSki llsWorkshopFeeC harge on the even
      afterupdate ConsultationSki llsWorkshopFee


      click on the afterupdate event in the property box for the
      ConsultationSki llsWorkshopFee and enter the following code
      ----------
      if ConsultationSki llsWorkshopFee = true then
      me.Consultation SkillsWorkshopF eeCharge = 800
      else
      me.Consultation SkillsWorkshopF eeCharge = 0
      end if
      -----------

      "ilushn" <msilushn@yahoo .com> wrote in message
      news:99a53f40.0 405210940.4d01c 11b@posting.goo gle.com...[color=blue]
      > I had this figured out a few days ago, then Access shut down and I
      > lost everything & can't remember how I did it.
      >
      > I have a check box (ConsultationSk illsWorkshopFee ) with an unbound
      > field (ConsultationSk illsWorkshopFee Charge) next to it. If the box is
      > checked I want a default amount of $80 entered into the unbound field,
      > which I can change if the person is receiving a discount. Otherwise,
      > if the box is not checked I want the amount to be $0. Can some tell me
      > how I should be doing this, I'm at wits end. I keep thinking I should
      > have the Default value be:
      > Iif(Consultatio nSkillsWorkshop Fee)=True,"80", "0" - but when I put this
      > in nothing happens... what's going on?
      >
      > Thanks![/color]


      ---
      Please immediately let us know (by phone or return email) if (a) this email
      contains a virus
      (b) you are not the intended recipient
      (c) you consider this email to be spam.
      We have done our utmost to make sure that
      none of the above are applicable. THANK YOU
      Checked by AVG anti-virus system (http://www.grisoft.com).
      Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004


        Comment

        Previous template Next
        Working...