1.) Report using crosstab query setting criteria's 2.)Form info to remain

[chacamasur]

I've attached a word doc... (with pictures ...ooooh) to try to explain my scenario better:

1.) Form enteries -- I would like to eventually use these entries as criteria’s on a report

2.) but -- The From if closed will reset/ or clear the values I would like the values to remain at all time.

 

[pbaldy]

This is your first issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

For the second, you'll need to save the values somehow. One way would be to bind the form to a table.

 

[chacamasur]

Thank you ... the link was helpful but might have opened up another can of worms. As in most cases usually happen.

I just want to bounce off my findings:

I have two reports .... Overall / Area

on my area report I entered in the parameter [Select Area] and that worked.

I opened up the overall report and it is now asking me for an area...

1.) this parameter does it link to the query??

2.) my code is different in the properties --> Recrod Source
Overall report doesn't show "parameter but Area report does

is there a way of making it specifically for the AREA Report?

 

[chacamasur]

so in the report it goes back to the Query before the Crosstab... and enters in SQL code.

I will take this query .. one with the Parameters required and one NO parameters and build the corresponding reports...

 

[pbaldy]

It sounds like you got it sorted out? The parameters required to stop the error go in the query, as described in the link.