INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

navigation form and report query question

navigation form and report query question

(OP)
Hi. I have a question regarding access navigation forms and reports.

I have a form [frmreports] that has 2 text boxes. txtdatefrom and txtdateto
in the report query, I use

CODE

Between [Forms]![frmReports]![txtfromdate] And [Forms]![frmReports]![txtToDate] 

Running the reports directly from the reports form works fine.
I added a navigation form to the project using Forms Navigation option.

Now when I try to run the reports above, it is making me put in the dates again
Does the navigation page treat the forms as a subform?
Thinking this, I tried to change the query code to

CODE

Between Forms![Shop Operations Navigation].frmReports.Form.txtdatefrom and Forms![Shop Operations Navigation].frmReports.Form.txttoDate 

But it still prompts me for the dates.
Help :)
Thanks
lhuffst

RE: navigation form and report query question

The obvious thing is that in the working code your field is

txtfromdate

and in the errant code the field is

txtdatefrom

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

RE: navigation form and report query question

(OP)
Thanks for the response. I caught that after I posted but still had the same problem.
On the reports:
I ended up putting the from and to dates in a global variable and used them in LABELS instead of textbox on the report.

On the query:
I changed the do cmd to include a where clause instead of having it in each query itself.

All seems well now :)
Thanks again

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close