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

  • Thread starter Thread starter Tara
  • Start date Start date
T

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
 
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
Click to expand...

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?
 
Back
Top