How can I sort the records as shown on a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that inputs records. Each record has a unique number. I
would like to have them in order as you scroll through the form. I have
sorted them on the table but they don't change order under the form.

Can this be done? Is it worth the time? Its not real important but would
be interesting.

Thanks.

David Rowe
 
create a Query of your form, then Put in Sort= Ascending..

I hpoe this help you..

ldiaz
 
DDrowe said:
I have a form that inputs records. Each record has a unique number.
I would like to have them in order as you scroll through the form. I
have sorted them on the table but they don't change order under the
form.

Can this be done? Is it worth the time? Its not real important but
would be interesting.

Thanks.

David Rowe
Click to expand...

Tables don't really have an order, think of them as a bucket of data.
You can set a sort in a query, report or form.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Form based on Query - Sorting Issue 6
Prevent sorting of data in a form 5
Access 2003 query for listbox sorts by Date but not most recent Time 8
Skip Records on a Form 2
Sort records in query when form is opened 3
Launching a Form from Within a Form to Create a New Record 1
sort records based on the system time 2
Record navigation 5

Back
Top