Order of Subforms

  • Thread starter Thread starter Calvin
  • Start date Start date
C

Calvin

I have a form that tracks annual events, with a subform for data specific to
each year. I would like for the current year's data to show up as the
default, but instead the first entry (1999) shows up and I need to scroll
ahead to find the current year. Any tips?
 
Clavin,
Do you need the current Year to show up on the Main form to filter out the
subform? Or do you need the subform to sort on current year?
 
The year only appears on the subform because the event information stays
constant from year to year (location, contact information, etc), so I need
the subform to sort by year and have the current year the default subform.

Does that make sense?

NK
 
I think I understand. You have a sub form that is controlled by a query and
in that query has a field with a Date in it. When that form is opened up as
a sub form you want the Data in it to sort by Date More Specifically the Year
with the most current year on top going to the furthers year away.

If that is the case then in the query (of the subform) drag another Date
field into the record set then Type the following
Year: Year([Your Field Date Name])
That will return only the years of the date 1999 2000 2001 etc etc…. Then
just sort ascending.
 
Hmm, I actually don't have a query for the subform, it is just based on a
table, and linked to the main form. Maybe it would work to create a query,
but I wonder if there is a way to sort the table in such a way that the
subform will display the entries in the reverse order (most recent vs. first
created).


AJOLSON said:
I think I understand. You have a sub form that is controlled by a query and
in that query has a field with a Date in it. When that form is opened up as
a sub form you want the Data in it to sort by Date More Specifically the Year
with the most current year on top going to the furthers year away.

If that is the case then in the query (of the subform) drag another Date
field into the record set then Type the following
Year: Year([Your Field Date Name])
That will return only the years of the date 1999 2000 2001 etc etc…. Then
just sort ascending.


Calvin said:
The year only appears on the subform because the event information stays
constant from year to year (location, contact information, etc), so I need
the subform to sort by year and have the current year the default subform.

Does that make sense?

NK
Click to expand...
Click to expand...
 
You can sort any field in a table when it is in Datasheet view and save the
change. That might work.


Also Simple fix is to create a Query baced on that table with all feilds,
sort then change the control soruse in your form to the query you created.
Will work fine then.

Calvin said:
Hmm, I actually don't have a query for the subform, it is just based on a
table, and linked to the main form. Maybe it would work to create a query,
but I wonder if there is a way to sort the table in such a way that the
subform will display the entries in the reverse order (most recent vs. first
created).


AJOLSON said:
I think I understand. You have a sub form that is controlled by a query and
in that query has a field with a Date in it. When that form is opened up as
a sub form you want the Data in it to sort by Date More Specifically the Year
with the most current year on top going to the furthers year away.

If that is the case then in the query (of the subform) drag another Date
field into the record set then Type the following
Year: Year([Your Field Date Name])
That will return only the years of the date 1999 2000 2001 etc etc…. Then
just sort ascending.


Calvin said:
The year only appears on the subform because the event information stays
constant from year to year (location, contact information, etc), so I need
the subform to sort by year and have the current year the default subform.

Does that make sense?

NK

:


Clavin,
Do you need the current Year to show up on the Main form to filter out the
subform? Or do you need the subform to sort on current year?

:

I have a form that tracks annual events, with a subform for data specific to
each year. I would like for the current year's data to show up as the
default, but instead the first entry (1999) shows up and I need to scroll
ahead to find the current year. Any tips?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top