Filter on Combobox Field in Data Project

[Matthew Pfluger]

I designed a Data Project that uses a SQL Server back-end and an Access 2007
front end. Many of the forms include Comboboxes for Lookup values. These
forms are in Datasheet view.

The Users need to filter the records by the displayed value, but the
autofilter drop-down forms do not detect the values. This feature worked in
ACCDB files. How can I get this to work with ADP/ADE files?

My users are all running Windows XP Professional on a corporate network.

Thanks,
Matthew Pfluger