Report criteria entry problem -- need help troubleshooting!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm having a problem in Access and can't figure out what's going wrong. I
have a form where the user selects something from a drop-down list then they
click on "generate report" and it should just show the items on the report
that correspond to the name. It's not working... Here's what I've tried in
order to troubleshoot:

* When I run the report-- it brings up the dialog box...I select the
value...I click "generate report" and the screen that comes up has nothing on
it (no header, etc.)
* When I run the dialog box by itself -- it brings up the dialog box...I
select the value...I click "generate report" and the report comes up with
everything on it (i.e. it doesn't limit the report to what I selected)
* When I run the query that was created for the report -- it brings up a box
asking me to enter the criteria (i.e. [Forms]![LookUp Dialog]![KSAName]). I
enter "Consulting" for the criteria and it returns the query with just
"Consulting" entries.

So... where is this falling apart? Does anyone have any ideas? I've been
trying to fis this for 2 weeks now. Thank you so much for your help!!!
 
Heather,

I suppose the form stays open when you click the "generate report" command
button, or at least it is not closed before the report is run, right?
Also, when you run the query manually, the form is again open, right? If the
form is open and you still get an input box when running the query, then the
problem is that the reference to the form control in the query has a
misspelling in it. Check and fix.

HTH,
Nikos
 
Back
Top