Adam, looking at your SQL it looks like you need to put a couple of spaces in.
e.g.
strSQL = "SELECT Count(PlaylistDetails.PLaylistDetailsID) AS NewTrackNum " & _
"FROM PlaylistDetails " & _
"WHERE PlaylistDetails.PlaylistID =[Forms]![Playlists]![PlaylistID]"
hope this helps
John