[AccessD] Not In List Not the Right Solution

Initially tried that - adding the record by code same as if it was the
record source for the combo box - but it went into a loop - kept calling the
not in list event after trying to go to the new record. 

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson
Sent: Tuesday, April 09, 2013 9:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com