Results 1 to 3 of 3
  1. #1
    karmaimages is offline Novice
    Windows 7 Access 2003
    Join Date
    Nov 2009
    Posts
    14

    Display Popup once textbox value = 0

    Hi,

    I have a text box on my form which show's the remaining balance of an account, once this reaches £0.00 i'd like a popup to display to advise the person inputting the data to write to customer to advise them the account is settled.



    The text box is txtRB

    How would you acheive this?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hmm...you're probably going to need code in the Current Event of the form.

  3. #3
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451
    sounds like you already have the hard part done, you thought thru the process you want. look into a "IF" statement, something like if (txtRB)=0 then do something. like ruralbuy said, put it in the current event of the form. personally i wouldn't use a popup message as if im inputting several things i'll forget about that popup when I'm done. try having it open a form to type the message to the customer?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 02-20-2015, 10:45 AM
  2. Replies: 14
    Last Post: 08-23-2014, 12:35 PM
  3. Textbox and contents will not display
    By DOC666 in forum Programming
    Replies: 5
    Last Post: 05-04-2014, 09:13 AM
  4. Replies: 2
    Last Post: 11-21-2013, 10:07 AM
  5. Replies: 2
    Last Post: 11-16-2010, 10:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums