new record problem

  • Thread starter Thread starter jamie
  • Start date Start date
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
 
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
 
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.
 
Back
Top