When I use a table to create a form, I get a result which is sorted according to order of original entry but images for each record are in color. To sort the form, I have to manually sort using the sort icon from the form navigation toolbar.
When I use a query, I can get it to sort as I want but the created form gives grayscale images in the records.
How do I produce a form where the images for each record are in color and the records are sorted the way I want before I open the form?
I am using Base 5.1 on a Windows 10 machine