Sorting Order of 3-part Form

K

KG

I know there is a way to fix this, but I can't seem to find it:

I have a form with two subforms. I would prefer the form and its subforms to
be displayed in the order in which they were entered. Instead they are
displayed in some order which I haven't yet figured out (probably because I
have only created 6 forms so far). How do I control the order in which the
forms are displayed?
 
J

John Vinson

I know there is a way to fix this, but I can't seem to find it:

I have a form with two subforms. I would prefer the form and its subforms to
be displayed in the order in which they were entered. Instead they are
displayed in some order which I haven't yet figured out (probably because I
have only created 6 forms so far). How do I control the order in which the
forms are displayed?
Click to expand...

Do you really mean "subforms"? A Subform is a form within a special
box on a main form (a "subform control"). It's just *there* - it's not
opened separately.

If you mean that you want to see the *data in* the forms displayed in
a particular order, then you must a) include a field in the table upon
which the form is based which is sequential; this could be an
incrementing Autonumber or a date/time field with a default value of
Now(); and b) base the Form on a Query sorting the data by that field.
If you base a Form on a Table you have no control over the order of
records.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps]
 
Top