Select Data Source window keep on poping-up

[Guest]

Hi,
I created paasthorugh query and Data Source for it for one report using
these instructions:
Create a passthrough query that executes
the stored procedure with any parameter dates
(say "qryExecSP")

Execute usp_qFlorida '2006-01-01', '2006-02-01'

then, change SQL of this query in code
to insert new parameters (say from form textboxes)

(example using DAO)

Dim strSQL As String

strSQL = "Execute usp_qFlorida '" & Format(Me.txtFromDate,"yyyy-mm-dd") _
& "', '" & Format(Me.txtToDate, "yyyy-mm-dd") & "'"
CurrentDb.QueryDefs("qryExecSP").SQL = strSQL

It all worked great for first report, but when I tried to create different
report using same process above, my report lost little square with a dot in
upper right corner (the one you can doubleclick on and gives you properties
for report) and Select data source window keeps on poping-up every second
unless I change record sorce to something else then that passthrough query.
Also, it prompts user to select record source when report is called. Does
anyone know how can I fix this?

 

[Guest]

OK I figured out little dot in the square. It is actually in upper left
corner and it is a part of ruler. How I done it, I have no clue . I still
have a problem with Select data source window pop-ups and I tried to recreate
datasource, query and report from begining, but it acts the same. Anyone
knows what this can be?