>>When I change from a TABLE to a VIEW, my FORM's display fields are not reflecting my new VIEW. What do I do?
>Try removing the alias reference in the control source (i.e instead of controlsource="MyTable.Field" use controlsource="Field"). This way if should use the currently selected area which you can control.
Thank you Larry..Now my VIEW is working... thanks again..
OK.. Now I need to do a two or move level sort...
I thought I would use two lists and I could
pick the fields I want to use in my sort string and move them form one
list to another.
Can you help get me going on this?