How-2 : Automatically Updating a Report

  • Thread starter Thread starter Charles L. Phillips
  • Start date Start date
C

Charles L. Phillips

Hello,
I am using MS-Access 97 for this process.
I have a products table, products form & a products report.
The products table only has 12 products listed.
As I add products, I do not want to rerun the report wizard.
Can/will someone tell he "how-2" automatically update the products report with code (Button)???

Charles L. Phillips
 
Adding more products should not require any changes in forms or reports. I
fear your table might not be normalized but since you haven't provided your
table structure(s) then I can't tell.

Please provide your field and table names and possibly even some sample
records.

--
Duane Hookom
MS Access MVP


Hello,
I am using MS-Access 97 for this process.
I have a products table, products form & a products report.
The products table only has 12 products listed.
As I add products, I do not want to rerun the report wizard.
Can/will someone tell he "how-2" automatically update the products report
with code (Button)???

Charles L. Phillips
 
Hello,
My tables are:
Categories
Customers
Mailing List
Orders
Products
Fields:
CategoryName
ProductID
ProductName
QuantityOnHand
QuantityPerUnit
ReorderLevel
SupplierID
UnitPrice
UnitsInStock
UnitsOnOrder
Shippers
Suppliers
Terms
Treatments
Visits
My report displays the following fields:
Product ID, Product Name, Quantity Per Unit, Unit Price,
Units In Stock
1 Soap 12 per case
$10.00 150
 
There should be no reason why the new products don't show in the report. Do
the new products have a valid Category value? Do the new products show in
the datasheet view of the report's record source? What is the sql view of
the report's record source?
 
Back
Top