Ive been looking all over trying to figure out how to have a select all at the top of a combo box.
What I have is a combobox Combo5 with a row source of
Code:
SELECT artist_id, artist_name FROM tblArtists ORDER BY artist_name;
A text box with a row source of
Code:
SELECT [tblTracks].title, [tblTracks].length, [tblGenres].music_genre_name, tblBitrates.Bitrate, [tblTracks].date_of_creation, [tblArtists].artist_name FROM tblBitrates INNER JOIN (tblGenres INNER JOIN (tblArtists INNER JOIN tblTracks ON [tblArtists].artist_id=[tblTracks].artist_id) ON [tblGenres].music_genre_id=[tblTracks].music_genre_id) ON tblBitrates.bitrate_id=[tblTracks].bitrate_id WHERE (((tblArtists.artist_id)=Forms![frmSearch]!Combo5)) ORDER BY [tblTracks].title;
And VBA code in the After update of the combo box
Code:
Private Sub Combo5_AfterUpdate()
Me.lstResults.Requery
End Sub
What I would like to have happen is a select all at the top of the combo box that is the default selection, and when its selected all records from the query are show.
Ive tried a bunch of Unions and such that I have seen online and cant get it to work.
Any suggestions?
Thanks
Ron
dBforums
>
Adding "Show All" to a combo box.
12-08-09, 18:04
Linear Mode
