hard time with criteria and report

Hi there i'm having a hard time:

i have a form and a rpt base on a qry

Name:

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 ?

thx

re: hard time with criteria and report

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
Pachydermitis

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

re: hard time with criteria and report

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
report.

re: hard time with criteria and report

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
complete]

cuz normally that's my criteria

any idea?

re: hard time with criteria and report

sorry its base on 2 different query.
1 for the forms
1 for the report


how the heck do i do this...

re: hard time with criteria and report

ok, i just had the code you told me into the second qry and it workds
fine.

thk u so much....

re: hard time with criteria and report

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