J
Jean
I have a form in "Continuous Forms" view, and my record
source is an sql statement with a sort order defined.
When the form opens it is sorted the way I have specified
in the record source. But if I right-click a field and
make a new sort-order, then this will be the order next
time I open the form.
How do I make sure that the sort order of my record source
is always used when opened?
I have tried to fill in the property "sort order" but that
just creates the weird situation that when the form is
empty and I use the up-arrow I run through "deleted"
records and all my bound fields show "#deleted#"...
source is an sql statement with a sort order defined.
When the form opens it is sorted the way I have specified
in the record source. But if I right-click a field and
make a new sort-order, then this will be the order next
time I open the form.
How do I make sure that the sort order of my record source
is always used when opened?
I have tried to fill in the property "sort order" but that
just creates the weird situation that when the form is
empty and I use the up-arrow I run through "deleted"
records and all my bound fields show "#deleted#"...