Sorting records on a tabular form

[Jen0dorf]

Hi

have a table based on a query with a view set to continuous -datasheet view

in the query I have set the order on a field called forename to a-z and when I run the query it is shown a-z

but when I open the form which is based on the query the order is not a-z is there a way of ordering the results?

thanks



Ian

[ssanfu]

OK terminology...
You have a query based on a table. Queries can only be in continuous datasheet view when executed.

A form can be bound to a table or query.

but when I open the form which is based on the query the order is not a-z

I have never seen this problem.
Are you sure the form is bound to the query and not the table??

Would you post the SQL of the query?

[Jen0dorf]

Hi

my query is below

SELECT tblDeceased.GraveID, tblDeceased.Mlink, tblDeceased.Plot, tblDeceased.GraveNo, tblDeceased.Forenames, tblDeceased.Surname, tblDeceased.Age, tblDeceased.YearOfDeath
FROM tblDeceased
WHERE (((tblDeceased.Surname) Like "*" & [Enter a Surname]))
ORDER BY tblDeceased.Forenames;

If I look at the properties of the form the record source is hown as qrySurnameSearch which is the name of my query= I assume that iswhat you mean by bound to the query?

thanks

Ian

[ssanfu]

If I look at the properties of the form the record source is hown as qrySurnameSearch which is the name of my query= I assume that iswhat you mean by bound to the query?

Yes, just wanted to make sure the query was being used.

SQL looks good also.



Could be corruption.
Try creating a new form, set the record source to the query, add the fields from the query to the form and view the form. Does the same effect happen?

[Jen0dorf]

Hi

just got back to this

I created a new query and a new form based on that query.

If I double click the query then every record is shown sorted by forename ascending number.

If I run the form is isn't

any other ideas?

thanks

Ian

[CJ_London]

it could be because the query you are using is a parameter query, prompting you for a surname when the form opens.

For test purposes, remove the where clause and see if you have the same problem.

[Jen0dorf]

Hi

thanks for the quick response

I removed the clause and it made no difference when running the query it's perfect , when running the form it's no longer sorted.

thanks again

Ian

[CJ_London]

try setting the form order by property to Forenames

If that doesn't work, suggest upload the db containing the table, query and form

[Jen0dorf]

Hi

thanks for the idea and yes that cured the problem!!!

Must have had a senior moment as I thought I'd read you couldn't sort or group a form

thanks million

Ian

[Jen0dorf]

Hi

note to self:

remember that when creating a form if you use the Wizard then Access adds a sort property to the form which appears to take precedence over any table sort

5 hours and lots of help !!! to learn this lesson

Ian

[CJ_London]

note to self - don't use the wizards if at all possible - it can take as long to undo all the defaults you don't want as it would to have created the form manually