Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2015
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    if The Item Not Exist Msgbox Appear, Access 2007

    Hi,

    i have a table which contain store item_no and it's description for each item, what i do that i make a form and textbox that when you enter the number if the item it display to you the description of that item, so here when i enter item that not exist in the table nothing displayed so i want if the item not exist a msgbox appear that the item not exists.


    Regards

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Put an unbound combobox at the top of your form, with the rowsource being your table. If user enters something "Not In List", you can pop a msgbox.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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