G
Guest
I created a form with a subform in my database. The main form only has three
fields: ID Number, Last Name, First name. The subform then has several
fields under it. After creating this form I created several reports,
queries, and macro's based on it and created a switchboard for the database.
I've now realized that when I created the form, I fixed it so its displaying
the entries in ascending order according to the ID number and I need it to be
in ascending order according to the persons last name so that when I go into
the form to enter new entries, the existing records are in there in
alphabetic order according to their last name. Is there a way for me to
change this without creating a whole new form and changing all my reports,
queries and switchboard?
fields: ID Number, Last Name, First name. The subform then has several
fields under it. After creating this form I created several reports,
queries, and macro's based on it and created a switchboard for the database.
I've now realized that when I created the form, I fixed it so its displaying
the entries in ascending order according to the ID number and I need it to be
in ascending order according to the persons last name so that when I go into
the form to enter new entries, the existing records are in there in
alphabetic order according to their last name. Is there a way for me to
change this without creating a whole new form and changing all my reports,
queries and switchboard?