Recent content by AllyJM

That's an interesting idea. I hadn't thought about doing something like that, but it makes sense. There is no real need to delete anyway as the table isn't very big. Thanks Acropolis, I'll try that.

Thank you Ranman256. That works a treat. Cheers

I have an access 2003 database table for songs containing the Artist's name and song title. On the form based on the table I have a combo box which is populated using a 'select distinct' statement. There is also a list box which displays all songs by selected artist. I am trying to find a way to...