>>>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?
sounds like a standard clipper-type task to me...