Charts on Forms and Reports

[rschultz]

Im having a problem similar to Nancy's back on 8-7-2000. I did a search for "Chart" and her's was the closest to my problem but the solution wasn't there.

I created a chart on a report and on a form and associated each to a query. When I double click either I get a prompt to enter the begining and ending dates: "Enter Paramater Value - Form!SWG!startdate" and then the form or report open with the correct data. However, if I open the form or report via another form that has textboxes where the values are entered, I get a blank chart. If I open another form instead of the form with the chart I get the data.

I have a command button on the form with the textboxes with the following code:

Docmd.OpenForm "Chart3", , , , , , STRSOURCE

I even put this code on the Form_Open event:

If Len(Me.OpenArgs) Then
Me.RecordSource = OpenArgs
End If

And my select statement (which I know works because I get data on my other form) is:

STRSOURCE = "SELECT * FROM [swg] " & _
"WHERE (([swg].[Bill-To DATE]) Between [Forms]![SWG Query]![startdate] " & _
" And [Forms]![SWG Query]![EndDate])" & _
" AND (([swg].Dept)=[Forms]![SWG Query]![combo17])" & _
"ORDER BY [swg].[Bill-To DATE]"

Anyone have any idea what I'm doing wrong?

Nancy, what was the solution you had? Your problem was identical to mine.