Filtering on multiple choices in a field on a data access pg

[Tara]

Help!
I am building a data access page for data entry. I need
the end-users to be able to choose multiple cities from a
drop down list, pull up just those records and then edit
the records. I tried using a pivottable but can't get it
to accept data entry on the data access page. It alos
won't allow filtering, it just selects all values in the
field. What am I doing wrong?

Please help.
Thanks

 

[John Vinson]

Help!
I am building a data access page for data entry. I need
the end-users to be able to choose multiple cities from a
drop down list, pull up just those records and then edit
the records. I tried using a pivottable but can't get it
to accept data entry on the data access page. It alos
won't allow filtering, it just selects all values in the
field. What am I doing wrong?

Please help.
Thanks

For one thing, a Pivot Table query will never be editable, since each
row of the pivot table corresponds to multiple actual table records -
Access can't uniquely determine what you want to update.

How are you doing your filtering? Care to post the code?