stumped and not sure where

tcommis

Registered User.
Local time
Today, 02:27
Joined
Jul 23, 2003
Messages
16
where to start?

I have a report running off a query.
Criteria is entered off a form.
when I enter the criteria by running the query I get the result I need but when I run it from the report it goes through the motions but I get no results (blank report). I know more info is needed but as a newbie I need some direction. HELP! -- getting aggrevated!

Tcommis
 
stumped

I’ve run into this with Access 97. The easiest way that I’ve found to correct it is to remove the criteria from the query, copy and paste the query and reenter the criteria in the new query.
 
thanks bat, but no luck - also I'm using 2000
 
If your entering the parameters via the form, you need to open the report via the same form
 
I think I'm doing that. is there something I can paste here that would make this easier to debug?
 
when I open the form that I made and enter the dates, hit ok, it closes the form and nothing happens. am I making this any easier to understand? sorry guy have some patients. I did follow the help step by step on how "use a form to enter report criteria"
 
if your passing the parameters via the form, the form has to stay open untill the report has opened
post the code behind the ok button
 
Sorry, I tried to send a .pdf. I've attached a .jpg this time
 
sorry Bat. I was out of the office- I don't see any attachment but that might be my firewall- I cannot download from the net.
 

Users who are viewing this thread

Back
Top Bottom