Form does not remain sorted alphabetically when re-opened

F

flygal5

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
 
F

flygal5

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.
 
K

KARL DEWEY

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