Order of data in forms

[Penz]

I've just upgraded from MS Office 2000 to Office 2007. I don't like it .... but I suppose I'll have to get used to it.

One specific problem I'm having in MS Access is this:

When I enter data into subforms, eg

Re: 1, The Road
Call out to electrical fault


Repair
Install new switch

it then gets displayed in alphabetical order rather than the order I've entered it:

Call out to electrical fault
Install new switch
Re: 1, The Road
Repair

... which looks nonsense .... so how do I stop it doing this?

[RuralGuy]

Add a TimeStamp field to your RecordSource fill it with Now() in the BeforeUpdate event of the SubForm. Then sort on this field in the query.

[Penz]

Allan

I did think about that ..... but I've already got thousands of entries over the last 5 years (That worked fine in MS Access 2000) ....... so if I add a time field, what happens to all those entries??

I'm hoping someone can identify a setting that can be altered to restore the status quo.

[RuralGuy]

What is the RecordSource of the SubForm? If it is a query then can you post the SQL for it here?

[Penz]

Hi Allan

Thanks for replying

It's not a query ... it's a form based on a two field table (job number & job detail) ... it is linked to a job table which has all the other fields, client number, job number, date, time, Etc. which is in turn linked to the client table.


Paul

[RuralGuy]

I would still create a query of that table because there is very little that can be done directly with a table. I take it you are filling in [job number] with the Link Fields and typing into the [job detail] field in the SubForm?

[Penz]

Yes Allan ... doing it exactly as you say for data input.

I use queries for variables, eg. to determine the data shown in a report ..... but I don't understand how or why a query would help here.

I ordered an MS Access 2007 'step by step' book last week, but the darn thing hasn't arrived so I can't even look it up.

[RuralGuy]

With a query you can specify an OrderBy clause.