Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing user parameters from a form to a report

Status
Not open for further replies.

jeannie322

Programmer
May 18, 2001
25
US


hey,

this is my first big project using forms & reports. I do have a general understanding and have created several general reports &
forms. But this is a little more complicated. We have a user that
wants to be able to pull specific info from a PO. (I got that) then
be able to do a comparison with 2 other vendors (got that) The
only problem I have incurred is getting the detail line item info to
print out on the report. I have passed all the user
parameters. But I cant get it to print the line items that I have
typed in from the 2 other vendors or the line items that I have
pulled in from the data base. Will I have to tell it to read each line
item? I am confused. I have 1 record that may contain 2 line
items and another that contains 10. I shouldnt have to set up
parameters in the report for all 10, should I? & if so then what
about in the form?

When I run my form & do a search for a PO it pulls up the line
item info (that was easy) I just cant tell it to put those line items in
my report? that is where I need help.

Also we are not saving this info to a table. Its just for them to
input and compare & print & thats all. No saving info.

Can anyone please help or direct me in any way as to how I can
tell it to read the line items & however may line items, print "x" #
of line items on my report?

Thanks a million!
Jeannie
-- if you need any clarification, I will gladly try!!!
 
jeannie, please be more detailed. i got confused.

regards,

microgreen
 
microgreen,, I already figured this one out months ago. We threw the info in a temp table. It was easy once I understood what in the world I was doing! LOL

Thanks tho!!
Have a great Holiday season!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top