By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

How to print report from navigation control

yosiro
P: 34
First, sorry for my english so bad.

I want to create print button from a form that not working when i use navigation control.

Step 1.
http://i47.tinypic.com/2wp1d9e.jpg
I want to print data from this form into a report. I create a form using navigation control and its automatically load a form specified.

Step2.
http://i49.tinypic.com/oku3a0.jpg
So I create a query information for the report as like as the form. I write criteria on ID that connect query report with the form.

Step3.
http://i50.tinypic.com/2zgrf5f.jpg
I create report with that query and use ID as a main.

and so forth.....

I test click the button on the original form, is ok, no problem: Like this:

http://i48.tinypic.com/1zgqjqv.jpg

But the problem rise when i click the button from other form that linked by navigation control, like this:

http://i46.tinypic.com/rbe7vt.jpg
Aug 31 '12 #1

✓ answered by twinnyfo

Yosiro,

It appears that you are trying to execute your report from two different forms. The report can only find data from the TOEFL form if it is currently open (and has data in the ID field.

If you use a query that has criteria based on a form, you must always ensure that before you open that query, the form is open first, and has data in the required fields.

Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,284
Yosiro,

It appears that you are trying to execute your report from two different forms. The report can only find data from the TOEFL form if it is currently open (and has data in the ID field.

If you use a query that has criteria based on a form, you must always ensure that before you open that query, the form is open first, and has data in the required fields.
Aug 31 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.