subform sorting

  • Thread starter Thread starter rml
  • Start date Start date
R

rml

I'm working with a subform that seems to be sorting by
itself. This what happens:

On the subform of a record I will type a, then b and then
c. When I go back to that record, it shows as b, then a
and c. I would like no sorting, just show as I entered
it.

Thanks.
 
rml said:
I'm working with a subform that seems to be sorting by
itself. This what happens:

On the subform of a record I will type a, then b and then
c. When I go back to that record, it shows as b, then a
and c. I would like no sorting, just show as I entered
it.
Click to expand...
The sorting of data on a form can be sorted in at least two ways:

Check the table for an 'order by' value.
Check the recordsource - if it is a query it can include sorting.

HTH

David
 
If the Value u enter is the Primary key then Access will sort on that unless
othewise specified
in other words you would need an autonumber field (as the primary key) to
get what you want..

Pieter
 
Back
Top