Report problems

T

tcorlew

I have a button on a form that allows you to print a report, vendor's
informations or customer's information and so on. The problem is that
everytime I press print, it will print all vendors or customers. I need it
to only print the current selection.

Table:
VendorID
VendorName
VendorAddress
........

Query:

SELECT Vendors.VendorID, Vendors.VendorName, Vendors!Address+","+[Address2]
AS [Shipping Address], Vendors!RemitToAddress+","+[RemitToAddress2] AS [Remit
To Address], Vendors.City,
Vendors.State, Vendors.Zip, Vendors.Contact, Vendors.Ext, Vendors.Email,
Vendors.RemitToAddress, Vendors.RemitToAddress2, Vendors.RemitToCity,
Vendors.RemitToState, Vendors.RemitToZip,Vendors.AccountNumber,
Vendors.AccountType, Vendors.Homepage, Vendors.Phone,
Vendors.ProductsOrServices
FROM Vendors
WHERE (((Vendors.VendorID)=[Forms]![Vendors]![VendorID]));

What am I doing wrong?
 
Top