S
Scott Viney
Morning All,
How is the order governed in a subform datasheet view?
For instance it is base soley on a table and I set the order to ascending
via the table headings for one field does it then take this as law when you
create the form?
Or say for instance I make a query to join information from one table and
another table then set the order to ascending for a certain field in the
query, does it then take this as law when you create the form?
Or is it possible to change what the field the records are sorted on in an
already created form? At the moment I have a subform where everything is
sorted by productid. If I change the query on which the subform is based to
order, ascending on the brand field, then reopen my form with this subform.
The subform flashes as though its doing something behind the scenes and my
totals in the main form dont have any total. If I change it back to the way
it was, no problems.
What am I missing here?
Scott V
How is the order governed in a subform datasheet view?
For instance it is base soley on a table and I set the order to ascending
via the table headings for one field does it then take this as law when you
create the form?
Or say for instance I make a query to join information from one table and
another table then set the order to ascending for a certain field in the
query, does it then take this as law when you create the form?
Or is it possible to change what the field the records are sorted on in an
already created form? At the moment I have a subform where everything is
sorted by productid. If I change the query on which the subform is based to
order, ascending on the brand field, then reopen my form with this subform.
The subform flashes as though its doing something behind the scenes and my
totals in the main form dont have any total. If I change it back to the way
it was, no problems.
What am I missing here?
Scott V