Connecting Tech Pros Worldwide Forums | Help | Site Map

hard time with criteria and report

NomoreSpam4Me@hotmail.com
Guest
 
Posts: n/a
#1: Nov 13 '05
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


dedejavu@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

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

NomoreSpam4Me@hotmail.com
Guest
 
Posts: n/a
#3: Nov 13 '05

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.

NomoreSpam4Me@hotmail.com
Guest
 
Posts: n/a
#4: Nov 13 '05

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?

NomoreSpam4Me@hotmail.com
Guest
 
Posts: n/a
#5: Nov 13 '05

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

NomoreSpam4Me@hotmail.com
Guest
 
Posts: n/a
#6: Nov 13 '05

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

dedejavu@hotmail.com
Guest
 
Posts: n/a
#7: Nov 13 '05

re: hard time with criteria and report


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

Closed Thread