Subform Query

[JC3]

Hi

I have a MainScreen Form in my Database which links to a subform giving a note of the Updates on the account. I have set this up as a Single Form with Navigation Buttons to move through these. All of this is fine except whenever you open an account it always shows the first update for the account.

Is there any way to change this so that the Navigation starts on the last account rather than the first. I know I could filter this but then you could not just flick back to look at previous updates.

Any ideas?

JC3

 

[ColinEssex]

If you have a date field can you not sort on that (descending)?

Col

 

[JC3]

Theoretically yes. But in an ideal world I would want the oldest Update to be record 1 and the Latest Update to be the last record with the SubForm opening on this record.

Does this make sense?

 

[godofhell]

Set the criteria on the query used to provide the details for your subform to sort descending using the recordID field. Since the record ID is autoincremented the highest number should be the last entry.