Filtering a Recordset

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

Hi. I'm using a combo box to filter records that are being returned
in a list box. The Row Source is based on a table:

SELECT DISTINCT DvdMovieTypeId, DvdMovieType FROM tblDvdMovieType_
UNION Select Null as AllChoice, "<<All>>" as Bogus FROM tblDvdMovieType_
ORDER BY DvdMovieType;

I use the <<All>> of course to remove the filter and return all records.
Query: When I select <<All>> all records are returned but the value in the
combo box disappears because it really isn't a value in the table.(I guess).
Is there some way of displaying the <<All>> after all records are returned
even if I can change the way I filter the records?
If anyone can point me in the right direction it would be appreciated.

Thanks,
James
 
It's getting upset about the null ID associated with <<All>>. Try .... 0 as
AllChoice.... instead
 
Back
Top