Order of Records in Header on a Main form

[zufie]

Hi,

I cannot understand why the order of records displayed in the Form
Header on a Main form display in descending order (that is from most
recently entered to first entered record).


Is there a way via the Main form properties to change this so that
the
records display in ascending order (in the order entered, that is,
from first record entered to most recent record entered)?


These records are entered on a separate Subform (FrmGranteeEntry) and
display on FrmGranteeEntry in the order entered.


Any ideas?


Thanks!


John

 

[Ron2006]

Look at the query that is the basis for the form that is showing them.
Be sure that there is a field included in that query that will put the
records in the sequence that you want (there apparently is since you
are saying that the records are in the reverse order to what you
want.) Now change the sequence for that field in the query to make
the records appear in the order than you want.

Ron

 

[KARL DEWEY]

records display in ascending order (in the order entered, that is, from
first record entered to most recent record entered)?
Records do not maintain an order of entry. They are stored in a table like
a 'barrel of bricks.' You must order them by sorting on a field.

 

[zufie]

Look at the query that is the basis for the form that is showing them.
Be sure that there is a field included in that query that will put the
records in the sequence that you want (there apparently is since you
are saying that the records are in the reverse order to what you
want.)  Now change the sequence for that field in the query to make
the records appear in the order than you want.

Ron

Thanks Ron, though there is no query behind the form.

These records are entered on a separate Subform and then are stored in
the MainID table.

John

 

[zufie]

first record entered to most recent record entered)?
Records do not maintain an order of entry.  They are stored in a table like
a 'barrel of bricks.'  You must order them by sorting on a field.









- Show quoted text -

Thanks Karl.

I did try sorting the field Award in Ascending (A to Z) order AND I
did try sorting the entire MainID table in Ascending (A to Z) order
but I get the same result?!

John

 

[zufie]

Thanks Ron, though there is no query behind the form.

These records are entered on a separate Subform and then are stored in
the MainID table.

John

Ok, ok.

I sorted the field, Date Last Updated, in Ascending order.

John

 

[zufie]

Thanks Karl.

I did try sorting the field Award in Ascending (A to Z) order AND I
did try sorting the entire MainID table in Ascending (A to Z) order
but I get the same result?!

John- Hide quoted text -

- Show quoted text -

Ok, ok.

I sorted the field, Date Last Updated, in Ascending order.

John

 

[zufie]

Ok, ok.

I sorted the field, Date Last Updated, in Ascending order.

John- Hide quoted text -

- Show quoted text -

Though I get the same result.

 

[zufie]

Look at the query that is the basis for the form that is showing them.
Be sure that there is a field included in that query that will put the
records in the sequence that you want (there apparently is since you
are saying that the records are in the reverse order to what you
want.)  Now change the sequence for that field in the query to make
the records appear in the order than you want.

Ron

Ron,

You are a genius!

You were right!!!!!!!!!

I dug some more and found a query that runs off the MainID field and
selected Ascending Sort for the ID field.

Problem solved!

Thanks,

J