if The Item Not Exist Msgbox Appear, Access 2007

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote