Datasheet order different between table and form

[Autoeng]

I have a form which contains a subform displayed as a datasheet for data entry in a multiuser db. This information goes into a matching table with no other information. Occasionally, the order of the information on the form and reports is changed from the entry order. I have called up the form which becomes the subform in datasheet view and it is in correct order. The table is also in correct order although both may be interspersed with other entries.

Does anyone have any ideas why this might be occurring? Refresh for the database is set for 60 seconds. Because this is a multiuser database could this be causing the problem?

Thanks in advance for any ideas you may have,
Autoeng

 

[Darrylles]

Hiya,

Unless you have an autonumber primary key field, you may never really know the order of entry.

Assuming that you do know because of a specific field entry such as date-time, are you saying that running the main form displays an order entry in the subform different to the subform run on it's own immediately after?

How can you compare? The subform will bring back less records in the main form than if run on it's own.

If you DO know, then I can only assume that the recordsource of the subform is being changed at runtime.

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Autoeng]

My primary key is an auto number field and does show that the form display is different from the table entry. I want the subform table to display in autonumber sequence but it isn't.

Autoeng

 

[Autoeng]

Some information that I forgot to provide in previous response is that the data subform was not set up to "Order By" anything. I want the table to display ordered by ECNPartsID. I put this in as ECNPartsID and [ECNPartsID] and neither had any effect. Should I be referencing the table and then the sort order? I wouldn't have thought so as the record source is the table.