Form does not remain sorted alphabetically when re-opened

G

Guest

I'd like to know why my Form does not remain or open in alpha order. I would
sort and save it but when I re-open, data is in random order. I've tried to
do this with the table thinking it would help.

Does anyone have an answer? Thx
 
G

Guest

Thanks, Karl. If I have already created the Form based on a Table and I want
to change it so it's based off the query that I just created (sorted), how
can I do that? thanks a bunch.
 
G

Guest

Open the form in design view, click on menu VIEW - Properties. Replace table
name in Record Source with the query name.
 

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

Alphabetical table 3
Columns not sorting properly. 2
Data in Access 2007 sub-form not requeried following updates via SQLServer delete trigger 2
Records duplicating through form navigation 2
DB Crashes when Form is Opened? 11
Sorting a Text Field MONTH by month not alphabetically 2
Sort contacts in two languages alphabetically 2
Table resorts rows and throws off order of second column 2

Top