SubForm don't change graphs

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top