Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms - creating a warning message (2000)

    One of my forms was created from an underlying table with just three columns regarding maintenance fees. If there is a maintenance fee owed, in other words an amount greater than 0 in the fees due field, I want a warning message to appear stating this. Can I creat a control box (not sure if using the correct word) in the form that has a rule such as "if field called dues owed amount is greater than $0, show this message." As you probably have guessed I am not very familiar with Visual Basic, but can be walked through it. I hope this makes sense. Thank you. Dorothy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms - creating a warning message (2000)

    If you want to display the warning on the form itself, you don't need code. You can place a text box on the form with the following Control Source property:
    <code>
    =IIf([Dues Owed]>0,"Note: there are fees due!")
    </code>
    where Dues Owed is the name of the field. Make the text box transparent, with a transparent border, and set its Enabled property to No and Locked to Yes.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms - creating a warning message (2000)

    Thank you Hans. It worked great! Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •