Hi Jim, I have used Dick's suggestion and encourage you to try it. I would like to offer a couple suggestions to it if I may. If you put a row like 'Add New Model' with a space in front of the first word, that choice will always be the first item on the pop up list assuming you have it ordered. Doing this also allows the user to tap the space bar to get back to that choice quickly. Second, if you put either a no duplicates rule or a primary key on the field name then the user can try to add a new model only to be told it is already there.
Regards, Dave Fitts State of Maine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Friday, October 16, 2009 3:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: getting info or enter new Jim: Put a row in the model data base listing 'Add New Model' When the user clicks that, use the exit eep on the field to trap 'Add New Model' and do whatever you need to do there to enter a new model. We do it all the time. Dick Fey Jim Belisle wrote: > > 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 >
