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

hard time with criteria and report

P: n/a
Hi there i'm having a hard time:

i have a form and a rpt base on a qry


Frm Notice
Rpt Notice
Qry Notice
The form and the rpt r base on the query, and the wuery use a criteria
to select the right ID.

Now i have a button on the form that when i click on it, it send all
the info on the form to the report. But it ask me again for the ID
number (cuz the RPT is base on the query).And if i remove the criteria
it prints everything for each ID.

I would like to be able to have a print button on my form, that send
all the info to the report but with the ID of the form i just filled.

can u help me ?


Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
put a control on your form - give it a name - lets call it MyID.
In your query, for the ID criteria put forms![Frm Notice]![MyID]
Now the query will read from the form.
Hope that helps

P.S. You can save yourself some hassle if you name your objects without
spaces e.g. frmNotice as opposed to Frm Notice

Nov 13 '05 #2

P: n/a
I'm not sure how u want me to do this.looks like a switching 4 quarter
for a dollar here.
The Rpt and the form r base on the same query.

i'm just misunderstanding,sorry, i feel pretty dumb right now.

on the Frm Notice there is already the ID.with the criteria asking me
wich ID i want to complete when i open it.On this form i have a save
button that call a print function.

do i have to make another qry?? cuz i have 1 qry for the form and

Nov 13 '05 #3

P: n/a
hey i just get it.

But now when i open my form it says forms![Frm Notice]![MyID] , and i
dont want the people to see this but to see [What ID do you want to

cuz normally that's my criteria

any idea?

Nov 13 '05 #4

P: n/a
sorry its base on 2 different query.
1 for the forms
1 for the report
how the heck do i do this...

Nov 13 '05 #5

P: n/a
ok, i just had the code you told me into the second qry and it workds

thk u so much....

Nov 13 '05 #6

P: n/a
You're welcome - a certain amount of hair pulling is required. :)

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.