Filter lists have disappeared (1 Viewer)

[ECEK]

I have just moved my data to SQL.
I have a split form that I can filter in the datasheet area. It normally has a list of all the options within that column but the list has disappeared.

It now has a to z sort and "Test filters" etc

I'm trying to understand what I have done wrong in order for this to stop?

Any advice is always appreciated.

 

[ECEK]

I've established that the list is there on my old Access system but doesn't work when the data is in the SQL server

 

[ECEK]

Found it.
File
Options
Current Database
scroll to:
Filter lookup options for........
tick the ODBC fields radio button.

Restart
Dealt with.