T
Tracy
I have a form named "Home" that has a subform named "t_subcommittees " that
has a set of command buttons that opens another form named
"CommunityHealthYear" and this form has two subforms named "BU_CH" and
"f_PrimaryEntry".
The command button on the first form opens up the other form and when I
click on a particular record in BU_CH it opens the other subform
"f_PrimaryEntry" based upon which record I select.
What I need is for the Home form command button to display only records on
the f_PrimaryEntry that have a session year = to the the "year" field on
t_session_year. And then on the other command, I need it to open up the
records that are not the current year but forward. I created an expression
in the query that took the year field - the session field and gave me a -1.
I could filter for all negative 1's which would essentially give me all 2006
record on the f_PrimaryEntry or whatever year we may be in. (The year field
in t_session_year is always the current year - i.e., 2005).
Is there a way to do that or am I going about this all the wrong way? I
appreciate your help...
Tracy
has a set of command buttons that opens another form named
"CommunityHealthYear" and this form has two subforms named "BU_CH" and
"f_PrimaryEntry".
The command button on the first form opens up the other form and when I
click on a particular record in BU_CH it opens the other subform
"f_PrimaryEntry" based upon which record I select.
What I need is for the Home form command button to display only records on
the f_PrimaryEntry that have a session year = to the the "year" field on
t_session_year. And then on the other command, I need it to open up the
records that are not the current year but forward. I created an expression
in the query that took the year field - the session field and gave me a -1.
I could filter for all negative 1's which would essentially give me all 2006
record on the f_PrimaryEntry or whatever year we may be in. (The year field
in t_session_year is always the current year - i.e., 2005).
Is there a way to do that or am I going about this all the wrong way? I
appreciate your help...
Tracy