[AccessD] Not In List Not the Right Solution

Whent his happens, I set the focus on a command button for adding a new record.

But I would think you can just add a new record by code in the Not In List event and set the last name field equal to the newdata value from the NotInList procedure.

Is there more to it than that?



Carolyn Johnson



  ----- Original Message ----- 
  From: Rocky Smolin 
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, April 09, 2013 11:23 AM
  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