new record problem

J

jamie

I have a query that appends a table. I also have a form on
this table that I can view while this happens. I'm using

FullRequery Me

to show the latest updates to my table. The only problem
is it puts the new record at the top. Anyway to force it
to put the new record at the bottom of the table(form)?
btw, this form is in datasheet view, Access 2003. Is there
any code to sort ascending by date? Maybe that would help?

jamie c
 
A

Anne

If you create another query from your table, you can use the sort with is
available with a query and sort by any field you want.
Than base your form on that querie instead of the table.
Anne
 
V

Van T. Dinh

You can also set the OrderBy and OrderByOn Property to sort the Records the
way you want.

Check Access VB Help on the above 2 Properties.
 
Top