Re: Subform changes record order after edits

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Did you specify a sort order in the query? To do so, pick the fields you
want sorted and set the to Ascending or Descending in the Sort row of the
query design grid. The columns will be sorted in the order you have them
listed from left to right. If you don't specify a sort order, there is no
restriction on what order the records will be returned.

--
Wayne Morgan
MS Access MVP


"Gary" <Gary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0668973E-12E3-4D02-A0FC-C0BB681C3314@xxxxxxxxxxxxxxxx
>I have continuous form subform "sfrmProductComponents on a mainform
> "Products" to enter/view Product details. The subform is based on a query
> joining several tables. I have a combo box which selects
> ComponentsCategories and displays a dialog form via the afterUpdate event
> to
> filter/Select a Component. There are other fields such as Quant, extended
> price etc.
>
> All is working well, however while testing the subform by changing
> category
> and component choices and varifying results, I noticed that the displayed
> records in sfrmProductComponents will randomly change order. All data
> seems
> accurate, the records just shift order. I have looked at the subform
> query
> and the datalist does not change relative order.
>
> I am new to Access and curious as to why this behavior is occuring. I
> would
> appreciate anyone's comments and recommendations.
>
> Thanks Gary
>


.

Relevant Pages

  • Re: order by
    ... Paul, the best method is to create a query, and use the Sorting row of the query to specify the sort order you want. ... If you don't specify any sort order, Access typically presents the records in the order of their primary key, though theoretically the order is undefined. ...
    (microsoft.public.access.queries)
  • Re: Subform changes record order after edits
    ... "Wayne Morgan" wrote: ... > query design grid. ... If you don't specify a sort order, ...
    (microsoft.public.access.formscoding)
  • Re: Query Builder vs. Using a Table Source
    ... I almost always use a query since I almost always want to specify the sort order ... that database I am messing with now has a pull-down mneu on one of the ...
    (microsoft.public.access.queries)
  • Re: subform limits
    ... To specify the number of records, or a percentage of records, use a query as ... A third option would be to apply a filter to the subform. ... > How can I limit the number of entries in the subform? ...
    (microsoft.public.access.forms)
  • Re: Sort order in a subform
    ... > How do I set the sort order in a subform using a field in the subform other ... > than the form/subform link field? ... the table and adding a sort to the query. ...
    (microsoft.public.access.forms)