Viewing a report from a form based on an ID# entered on form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am in the midst of setting up a quotation and ordering system for the company I work for.

I have successfully created the quotation section and I am now working on the ordering system - in particular the enter new order page. On my ordering page is a field called Quotation Ref which refers the order to a past quotation, I want to make it so I can add a button next to this quotation reference that when clicked will load up the report of the quotation based on the number in that field. How do I do this? Thanks in advance.

The Quotation report name is: Quotations
The Quotation Ref field on my form is called: Quotation Ref
The primary key field in the quotation database which I want to refer to is: QuotationID
 
Richard,
In the query behind your report, set up a criteria for your [QuotationID]
field that says... (use your own form name)
= Forms!frmMyFormName![Quotation Ref]
Now when the report opens, the only record that will show will be the one
with a QuotationID equal to the value of [Quotation Ref] on your open form.
hth
Al Camp

Richard Horne said:
Hi,

I am in the midst of setting up a quotation and ordering system for the company I work for.

I have successfully created the quotation section and I am now working on
Click to expand...
the ordering system - in particular the enter new order page. On my ordering
page is a field called Quotation Ref which refers the order to a past
quotation, I want to make it so I can add a button next to this quotation
reference that when clicked will load up the report of the quotation based
on the number in that field. How do I do this? Thanks in advance.
The Quotation report name is: Quotations
The Quotation Ref field on my form is called: Quotation Ref
The primary key field in the quotation database which I want to refer to
Click to expand...
is: QuotationID
 
Back
Top