Okay, i'm lookig for somebody that

[sedilson]

Okay, i'm lookig for somebody that can help me....

hopefullly i can send this database to somebody and give them an explanation.


I have a form that a user comes in and selects a report inside that form a have a combo box with different company names and contract numbers.
Now i have a generic report that has companies information such as Vendor Name, Location, Part Number Plant Number etc. (all this information is stored inside a table (tblContracts)

Now what i would like this do i based on what the user select in the combo box the specific information for that company should come out in the generic report

So example.

cboContracts
-------------
Blackhawk
Delphi
General Motors


Generic report
--------------
Vendor Name :
Location:
Plant Number:
Contract Number:
etc


so if the user selects Blackhawk it should input the information for Blackhawk into those specific fields.........

I u need a better description please ask!

Thanks in Advance

 

[jebry]

Hi!

All you need to do is create a button the form with the combo box and in the click procedure put:

DoCmd.OpenReport "YourGenericReport, acViewPreview, , "YourCompanyField = '" & Me.YourComboControl & "'"

hth


Jeff Bridgham
bridgham@purdue.edu