I have a combo box which is used to allow the to select a response source from a preset list.
The sources are in a table called lkup_RepsonseSources
The SQL behind the combo box rowsource is as follows:
SELECT lkup_ResponseSources.ResponseSourceID, [SourceRef] & " : " & [SourceDescription] AS SourceName
FROM lkup_ResponseSources
ORDER BY [SourceRef] & " : " & [SourceDescription];
What I want to do is add an "Other" option into the list, but always have it appear at the bottom of the list.
Any ideas?
The sources are in a table called lkup_RepsonseSources
The SQL behind the combo box rowsource is as follows:
SELECT lkup_ResponseSources.ResponseSourceID, [SourceRef] & " : " & [SourceDescription] AS SourceName
FROM lkup_ResponseSources
ORDER BY [SourceRef] & " : " & [SourceDescription];
What I want to do is add an "Other" option into the list, but always have it appear at the bottom of the list.
Any ideas?