If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report problems
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
Exporting Report To Excel | PK | Setting Up & Running Reports | 0 | October 4th, 2005 03:49 PM |
Summary Report Problems | cleoozo | Setting Up & Running Reports | 0 | December 30th, 2004 06:13 PM |
Problems totalling subreport data on main report (A-2002) | Marshall Barton | Setting Up & Running Reports | 0 | June 23rd, 2004 08:01 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |