Subform record order? (1 Viewer)

[Atthe]

Hi All,

My database seems to have developed an issue. When I am adding new records using an emulated spiltform the record goes into the split form at the bottom (expected behaviour) but when I requery/or close re open the form all the records I have entered today appear first despite the PK being larger than the existing records below?

the table is sorted smallest to largest on the correct field

I have tried adding order by in vba in the on load event but this doesn't seem to make a difference

Does anyone have any ideas?

Cheers

 

[arnelgp]

use a "real" split form.

 

[CJ_London]

the table is sorted smallest to largest on the correct field

what is the 'correct field'?

 

[Atthe]

what is the 'correct field'?

the primary key, the field name is ID Number

 

[Gasman]

Hi All,

My database seems to have developed an issue. When I am adding new records using an emulated spiltform the record goes into the split form at the bottom (expected behaviour) but when I requery/or close re open the form all the records I have entered today appear first despite the PK being larger than the existing records below?

the table is sorted smallest to largest on the correct field

I have tried adding order by in vba in the on load event but this doesn't seem to make a difference

Does anyone have any ideas?

Cheers

Yes, you are causing this in some way. I say that, as I had the same setup and it works as expected.

 

[Atthe]

Yes, you are causing this in some way. I say that, as I had the same setup and it works as expected.

Yes I agree just wish I could work out what I have done

 

[Gasman]

Well look at the data tab for the mainform, as if the subform has the latest at the top, so will the mainform.

 

[Atthe]

I can't see anything amiss

 

[Gasman]

So you are NOT using a table, but a query which is not even sorted?

 

[Pat Hartman]

Add an Order By clause to the form's RecordSource query and remove the sort property.