Okay, I'm kind of a newbee to Access. I'll try to explain what I've done
thus far and
what I'm trying to do.
  I've put a combo box (named: Artist1) in a form (named: Artist2) and I've
populated this
 combo box from a table (named: ArtistBand, field named: ArtistBand).
  Everything works fine with that.
  Now, I'm using the "On Not in List" event for new data entries in this
combo box. I,ve
 set the "Limit To List" data to Yes and I,ve added to following info to the
"On Not in List"
 event:
           Private Sub Artist1_NotInList(NewData As String, Response As
Integer)
                   Dim varArtistBand As String
                   varArtistBand = NewData
           Response = acDataErrAdded
     
End Sub

   Now, when I run the form, I get the following Access message:
       "The text you entered isn't an item in the list."
   So, I'm missing something(s) somewhere. Any suggestion?

 Secondly, I'm trying to assign a variable (as shown in the event code above)

   from 21 different combo boxes and, once that is done, added those 21
   variables into 7 different tables (tables that are all linked to each
other in
   some way). At least that's the plan, unless    there is a easier
way/method.

 I've spent quite a bit of time searching through past threads/subjects, but
couldn't
  find anything that addressed what I'm doing.

 Thanks for any assistance you could possible provide.
 Rod