I am using Windows & 64X and Access 2010 32X
I have a form in Datasheet view where the dropdown for filter displays on a field are different in Regular access backend link from SQl backend link connection.
See attached files. With Access BE I get the regular dropdown with selections, with SQL I just get A-z or Z-a Filters.
There is one more thing, this forms data comes from four tables to display a record.
I think it is just a setting, but have not been able to locate it.
Like to get the SQL to look and act like the Access 2010 BE dropdown.
Can anyone help?