flexible query

[clueless21]

I have a search function that returns a list of songs. This function searches by Artist, Title, Album and Genre of music. The search works fine enough. I took the results of this search and put them into a form, from which a user can select one of the songs that have been returned. I have built an append query that automatically tracks each selected item, but it is not working the way that I want it to. I have the append query set that on a double click it will put the records that are selected into two other tables to do the tracking, but instead of taking that individual record, it takes all of the records that are displayed in the result form. how can i have a flexible query that takes the songs that are selected as opposed to the entire list?

 

[lightray]

Hi, maybe set up a option button or a check box on the form row, then if checked just move the ones where condition is checked. lightray

 

[clueless21]

That is a good suggestion, but how would I associate the song with the check box, my search function automatically pastes its results into a new form in the form of a text box.

 

[lightray]

How does the user select them on the form? what criteria are you using to get the selection for the append?

 

[clueless21]

the form comes up as a text box and the user can select a record, and on double click it appends the other tables with all of the records that are in the search as opposed to only the selected ones. I do not have any criteria, which is the problem, i am just returning the whole table