Rocky Smolin
rockysmolin at bchacc.com
Tue Apr 9 14:08:57 CDT 2013
I've done that lots for values that need to be added to the combo box. But this case is a bit different. Long story is that the problem is that when they have a new person to add, they user the person combo box to see if they are already there. If not the back out and click the Add button. They find that inconvenient. What they want is to go to the Find first, drop down the combo box, and, if the person is not in the list, go directly to the Add function - GoToRecord acNewRec. Can't get that to work. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Tuesday, April 09, 2013 10:24 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Not In List Not the Right Solution Hey Rocky I do not understand your problem. From someone so attuned to Access. Do you not trap for Not In List, then popup a form, asking the client to verify they want to add the new entry to the list? Then in VBA you add the new entry to the lookup table, requery the list and then set focus to the new entry??? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: April-09-13 11:24 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Not In List Not the Right Solution Dear List: I have a request from a user that when they try to find a name in a combo box if the name is not there, that the program go to add a new record and place the data entered in the combo box in the last name field and let them finish entering the new data. I tried the NotInList event until I realized this is to add entries to the combo box. But I can't seem to get it to behave properly - it goes into a loop displaying my "add then new guy now?" not in list message. I think Not In List is not the best way to do this, but don't know how else. Any ideas? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3272 / Virus Database: 3162/6234 - Release Date: 04/09/13 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com