Dennis, The WHERE clause in the automatic popup is this: WHERE Model# LIKE '&%' ORDER BY Model# If I immediately hit the escape key I get an error "No values chosen from the list." But no error number is with it.
If I enter a few letters and hit enter, a list of possible matches come up. If I then hit escape I get an error message with the error number. That error message I can suppress but not the first one. Should I try something different? Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Friday, October 16, 2009 2:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: getting info or enter new That should be SET ERROR MESSAGE nnnn OFF/ON Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty Sent: Friday, October 16, 2009 2:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: getting info or enter new Jim, Can you have an EEP that includes SET ERROR nnnn OFF when you enter the field, and another that turns it on when you leave ? Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Saturday, 17 October 2009 8:25 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - getting info or enter new While entering orders in the Model field, I give the option for the entry person to lookup the model with a pop up menu. They also have the option (by pressing a button next to the model field) of entering a new model into the proper table so it is available to use "on the fly". This is working fine. I have tried making the popup automatic. That works except if they realize they need to add a model because what they are looking for is not there (such as parts orders, etc.) when they escape they get an error because no value is picked from the popup. When using an automatic popup is there a way to suppress the error message if they do not choose an item? My purpose is to force them to look carefully first before entering new models such as parts, but get rid of the error message if they do have to enter a new model after searching carefully. Jim
