Run a Macro to Sort a Table in Access 2003

[slifer666]

Ok,

I have a table that has new data added into it through forms, and i want the data to be sorted when a new record is added.

The person that the database is for is new to Access and therefore is not 100% competant at it.

I wanted to add a button onto the forms that would run a macro that would sort the data. Is there a macro in Access that can do this?

Cheers,

Slifer

 

[Ron_dK]

I wanted to add a button onto the forms that would run a macro that would sort the data. Is there a macro in Access that can do this?

Cheers,

Slifer

You don't need a macro to sort your data. Simply bound your form to a query based on your table and with that, you'll be able to sort any data the way you want.

Hth

 

[slifer666]

You don't need a macro to sort your data. Simply bound your form to a query based on your table and with that, you'll be able to sort any data the way you want.

Hth

Thanks, and how exactly do i do this (its been a while since i used Access!!)

 

[Ron_dK]

Make a query based on your table.
In the query design grid , you can enter sort data functions and put in criteria.
Bind your form to this query and in the form you secondly have the possibility to filter and sort ( records> filter - sort) .

Hth

 

[slifer666]

Cheers

That worked brilliantly thanks

Regards