A
an
Hello!
I am in a situation that I don't to see why it doesn't
work.
I have:
1 - T_AllData: Name, Date, Value, ... fields
2 - T_MonthYear: MonthYear field, type JAN01, FEB01,
MAR01, ...
3 - CrosstabQueries based in T_AllData; One for each
MonthYear and work fine.
4 - F_Main with Record Source empty;
4.1 - CboMonthYear to choose MonthYear, based
inT_MonthYear
4.2 - cmdButton to CONFIRM (the previous choose in
CboMonthYear) with code in OnClick EventProcedure:
'______Start Code
Private Sub cmdConfirm_Click()
Dim strQueryName As String
strQueryName = Choose
(Me.CboMonthYear.Value, "Q_CrosstabJAN01", "Q_CrosstabFEB01
", "Q_CrosstabMAR01")
DoCmd.OpenForm "SubF_Graph", OpenArgs:=strQueryName
End Sub
'______End Code
5 - SubF_Graph.
On Load EventProcedure:
'______Start Code
Me.RecordSource = Me.OpenArgs
'______End Code
Objective:
1 - To choose MonthYear in F_Main (CboMonthYear9;
2 - To confirm with CommandButton in F_Main;
3 - Change graph in SubF_Graph, based in respective
CrosstabQuery choosed in CboMonthYear (F_Main).
This... don't work.
For this, I would like your help, please.
Thanks in advance.
an
I am in a situation that I don't to see why it doesn't
work.
I have:
1 - T_AllData: Name, Date, Value, ... fields
2 - T_MonthYear: MonthYear field, type JAN01, FEB01,
MAR01, ...
3 - CrosstabQueries based in T_AllData; One for each
MonthYear and work fine.
4 - F_Main with Record Source empty;
4.1 - CboMonthYear to choose MonthYear, based
inT_MonthYear
4.2 - cmdButton to CONFIRM (the previous choose in
CboMonthYear) with code in OnClick EventProcedure:
'______Start Code
Private Sub cmdConfirm_Click()
Dim strQueryName As String
strQueryName = Choose
(Me.CboMonthYear.Value, "Q_CrosstabJAN01", "Q_CrosstabFEB01
", "Q_CrosstabMAR01")
DoCmd.OpenForm "SubF_Graph", OpenArgs:=strQueryName
End Sub
'______End Code
5 - SubF_Graph.
On Load EventProcedure:
'______Start Code
Me.RecordSource = Me.OpenArgs
'______End Code
Objective:
1 - To choose MonthYear in F_Main (CboMonthYear9;
2 - To confirm with CommandButton in F_Main;
3 - Change graph in SubF_Graph, based in respective
CrosstabQuery choosed in CboMonthYear (F_Main).
This... don't work.
For this, I would like your help, please.
Thanks in advance.
an