Form not passing the arguments to the query

[elliot315]

I have a report that summarizes the sales for a week... on a table I have all the cash reported by date and on other queries I have the details for the sales. The problem is that the form that calls the report and pass the arguments to the cash total query is not passing the arguments to the query (the FROM DATE and TO DATE). If I run the query alone.. it gives me the total cash for the date...the form is programmed to go invisible after opening the report... is that a problem for that query? Everything else on the report is all right.

 

[KenHigg]

Post some code on how you're referencing the form fields. I'm guessing you need to place pound signs around something - ?

 

[neileg]

the form is programmed to go invisible after opening the report... is that a problem for that query? Everything else on the report is all right.

Invisible or closed? If it is closed then the data in those controls is gone and can't be passed to the query.