If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SubForm don't change graphs
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 EventProcedu '______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 EventProcedu '______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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Continuous Subform / Form - Orphan records | Rich J | Using Forms | 6 | October 15th, 2004 08:59 PM |
How to change the resolution of graphs in Excell | naveed | Charts and Charting | 2 | October 8th, 2004 01:31 PM |
Problems with DSum or Running Sum on a Subform | drhalter | Using Forms | 4 | August 15th, 2004 06:03 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Can't figger this'un out. | Jerry | Running & Setting Up Queries | 7 | July 7th, 2004 06:12 AM |