simple if you know how I'm sure?

[joe90]

Hi,
I am trying to simplify a working process and would appreciate any help or light you could shed..
here goes...
I work in the print trade, and with all new regulations and stuff I have been asked to record all paper usage that holds an FSC logo! (which is basically trees from managed forests) all good..
This entails logging all fsc paper usage from when it comes in (Inv_Number_IN), (Inv_Number_oUT), how it was used (Job_Number) etc...
I have 2 tables
IN_TBL and OUT_TBL
My IN_TBL consists of the follwing:
DATE
PO_NUMBER_IN
INV_NUMBER_IN
QUANTITY_PURCHASED
GSM
MERCHANT
SIZE
FINISH
CLAIM
PRODUCT_CODE
My OUT_TBL consists of:
DATE
PO_NUMBER_OUT
INV_NUMBER_OUT
JOB_NUMBER
GSM
QUANTITY_USED
INVOICE_IN
PO_IN
CLIENT
CLAIM
PRODUCT_CODE
-----------------------------------

I have 1 form [form1] with 1 field [Inv_Search]...

---------------------------------
I have one report [Usage_Report] which displays pretty much all the data from both tables!

-----------------------------------------

I have 1 query [Query1] Which is asking for most fields from both tables, with set criteria [Forms]![Form1]![Inv_Search] in the (INV_NUMBER_IN) Column.

-------------------------------------------

I would like to be able to enter just the invoice number[Inv_Search] into a single field form [Form1], and preview the report on the click of a button within the same form (button:view report).

If anyone could kindly head me in the right direction " I love you long time"
Its cracking me I think....as simpe as it is...I have done stuff like this in the past but its been some time and can't believe how much I have forgotten,..


Kindest regards and thanks again for any help you can give..

Joe

 

[Galaxiom]

Try to phrase you questions without all the irrelevant background and you will get faster answers.

All you needed to ask is how to open a Report in Preview mode based on the value in a control on the form.

Run this code from the button

DCmd.OpenReport "reportname", acPreview, , "somefield = Forms!formname.controlname"

Info about the OpenReport Method:
http://msdn.microsoft.com/en-us/library/bb238032.aspx

Otherwise use the control as a criteria in the query that is the report's Record Source property. This can substitue for the Where clause string in the above command.


Please also read this post:
http://www.access-programmers.co.uk/forums/showthread.php?t=170250