[Bottlesford]

Our database is Access2000 running on WindowsXP. We have a subform based on a table, where users can enter data and also enter a digit to indicate the order in which the entries appear. On loading, the subform is set to load the entries in this order. Also on the subform is a command button (Me.Requery) to sort the entries if a user wants to change the order of new entries.
The subform works fine when standing alone, but when used as a subform within the main form, the entries do not load in order, and the sorting button doesn't work.
Any ideas?

[OBP]

Bottlesford, welcome to the Forum.
Subforms quite often react differently when on a Mainform, but I can't see why the Me.Requery is not working, unless the button is on the mainform instead of the Subform.
In which case it would have to be
Me.Subformname.Requery
where Subformname is the name of your subform provided by the Editor's wizard.

[Bottlesford]

OBP - thanks for the quick reply - the control is indeed on the subform, and this subform works OK in an earlier, simpler version of our database. If you've any other pointers about why subforms behave differently on the mianform I'd be grateful to hear

[OBP]

Can you post or email a zipped copy of the database, it does not need any data in the tables for me to test the forms, I can add a couple of dummy records.

[Bottlesford]

OBP - thanks for the offer, but apparently I'm too far down the foodchain to email you directly, and the zipped file is too big to attach here. It is quite a complex database...

[OBP]

No it is not a matter of "Foodchain" position, you just need my email address as I don't think the Forum one does Attachments.
One thing to check, did you Compact & Repair the database prior to Zipping, as databases under development grow alot of unecessary stuff called bloat (it stores every change you make).
I will Private Mail you me email address if it is still too large to post as an Attachment on here.

[OBP]

Can you import the tables for me, you can delete the records. Because the Tables are linked I can't work with the Queries or Forms