Hi Scott
Take a look at Rick's video on taking attendance. I think it will help you with appending records using a recordset.
HTH
John

Thanks John.  Merry Christmas!

John,

I have done several searches.  "Taking attendance", "attendance" without luck.  Can you locate the video and share the link?

Thanks

After reading my original post I thought it sounds about as clear as mud what I am trying to do.  Let me simplify it some.  I have a listbox with 24 items.  When items are selected, each item goes into a result field on the form (& table) after being concatenated.  Later, on a different form, I am trying to query for a specific >> ONE << of the several items possible in that result field, from the original table.  How do I parse out the individual items?  

From the listbox the concatenated items are formatted  "whatever" & ",_"   .  Is it possible to query for string variables between the comma space?  Left of comma maybe?

Sticking my nose in.
The attendance stuff is started in Access Expert 14 and gone more in depth in Access Expert 15.

I often find a simple "Ctrl-F" in the Microsoft Access Outlines page will give me results the Search feature does not.

I'm having trouble visualizing what you are trying to do but it looks like you're complicating things rather than simplifying them. You probably need to provide some pictures / screen shots to help us see 1. your structure and 2. what you want.

String Functions is what you need to pull data out from with in a string.  Covered even more extensively in Access Expert 25 & on.

If you have completed the Beginner Series covered in the MyOLP Beginner you might want to ask about upgrading to the Expert MyOLP.  I highly advise -  No Hopping around.  Each Expert builds on the previous course.
See the Skipping Levels

Scott,

i am not an expert nor have I signed up for those courses.

On a form which has song titles, artists, year published and lots of other information. I have a list box with music genres on that form.  On the list are things like Pop  Rock  Heavy Metal  Funk  Soul and so forth.  If three items are selected in the listbox, the form concatenates them when I click a button to save them.  They might appear in a field as "Pop, Funk, Soul,"  if those three are selected.  What I want to do later, on a different form, is to pull those items out separately.  I am trying to parse out each item I mean I want to search for songs with Pop as a genre.  This would identify "pop," (how it was concatenated) and find all the songs with that.  If there are multiple genres, like "Pop, Funk, Soul,"  the song should pop out in a search for any of those items.  I cant figure out a query.

It took a while but I finally made this code which seems to work for concatenating;

Private Sub SaveGenreButton_Click()
    Dim varItem As Variant
    Dim strSearch As String
    Dim Task As String
    
    For Each varItem In Me.ListGenreSelect.ItemsSelected
        strSearch = strSearch & Me.ListGenreSelect.ItemData(varItem) & ", "
    Next varItem
    
    If Len(strSearch) = 0 Then
        Task = "select * from ListGenreSelect"
    Else
        strSearch = Right(strSearch, Len(strSearch))
        Task = "select * from ListGenreSelect where([ID] in (" & strSearch & ", " & " ))"
        
        Me.Genre = (strSearch)
    End If
        
End Sub

My question is how to pull them individually from a query search.  The only alternative I can see is to have checkbox for each genre, which I am trying to avoid.  If I did go to check boxes, I would then have to concatenate them individually, which would take a TON of coding to do but getting query results would be simple.