Enter Parameter Value .WHY?

[Phil Smith]

I get the "Enter Parameter Value" Dialog Box for
[InvoiceFlatFile for Multiselect].[Brand].

Please note the Parameter declaration for
[InvoiceFlatFile for Multiselect].[Brand]
in my code...

What's up with that?


PARAMETERS [Forms]![MultiselectForm]![STARTDATE] DateTime,
[Forms]![MultiselectForm]![ENDDATE] DateTime, [InvoiceFlatFile for
Multiselect].[Brand] Text ( 255 ), [InvoiceFlatFile for
Multiselect].[Category] Text ( 255 ), [InvoiceFlatFile for
Multiselect].[CustType] Text ( 255 );
SELECT CustomerFlatFile.Type AS CustType, CustomerFlatFile.Terms AS
CustomerTerms, CustomerFlatFile.Territory, CustomerFlatFile.customer_id,
CustomerFlatFile.name AS CustName, CustomerFlatFile.PriceType,
invoice_h.invoice_id, invoice_h.invoice_date, term.name AS OrderTerms,
brand.name AS Brand, item.old_sku, invoice_d.item_id, item_types.name AS
Type, division.name AS Division, category.name AS Category,
item.short_desc, invoice_d.ship_qty, invoice_d.cost, invoice_d.price,
invoice_d.discount, invoice_d!ship_qty*invoice_d!price AS ExtCost,
invoice_d!price*invoice_d!ship_qty AS ExtPrice,
invoice_d!ship_qty*(invoice_d!price-invoice_d!cost) AS ExtMargin
FROM item_types INNER JOIN (category INNER JOIN (division INNER JOIN
(term INNER JOIN (brand INNER JOIN (item INNER JOIN (invoice_d INNER
JOIN (invoice_h INNER JOIN CustomerFlatFile ON invoice_h.customer_id =
CustomerFlatFile.customer_id) ON invoice_d.invoice_id =
invoice_h.invoice_id) ON item.item_id = invoice_d.item_id) ON
brand.brand_id = item.brand_id) ON term.term_id = invoice_h.term_id) ON
division.division_id = item.division_id) ON category.category_id =
item.master_category_id) ON item_types.type_id = item.item_type
WHERE (((invoice_h.invoice_date)>=[Forms]![MultiselectForm]![STARTDATE]
And (invoice_h.invoice_date)<[Forms]![MultiselectForm]![ENDDATE]+1) AND
(([InvoiceFlatFile for Multiselect].[Brand])="Creature" Or
([InvoiceFlatFile for Multiselect].[Brand])="Santa Cruz") AND
(([InvoiceFlatFile for Multiselect].[Category])="Decks" Or
([InvoiceFlatFile for Multiselect].[Category])="Sweats" Or
([InvoiceFlatFile for Multiselect].[Category])="T-Shirts") AND
(([InvoiceFlatFile for Multiselect].[CustType])="CORE WHOLESALE"));

 

[Jerry Whittle]

What is "InvoiceFlatFile for Multiselect"? It doesn't seem to be a table or
even a form. As the Where clause seems to already have the data, it would be
rather convoluted to use Or statements to narrow down the data by asking for
a known value.

 

[Duane Hookom]

I don't see [InvoiceFlatFile for Multiselect] in your "FROM" clause.