Filter by Forms no longer works with linked SQL table

M

Michael Brennan

Hello,

I recently upsized a database and changed linked tables from linking to an
access database to a SQL database. Now, when a user right clicks on a data
item and chooses "filter by selection", they no longer get results. is there
a way to make "filter by selection" work with linked SQL tables?
 
R

Rick Brandt

Michael said:
Hello,

I recently upsized a database and changed linked tables from linking
to an access database to a SQL database. Now, when a user right
clicks on a data item and chooses "filter by selection", they no
longer get results. is there a way to make "filter by selection" work
with linked SQL tables?
Click to expand...

Works for me. What is the field's DataType? Yes/No fields might not work
after conversion to a SS back end, but other types should be okay.
 
Top