A
Alex
I have a datasheet subform [Item Order Details Subform]
that is part of the [Main Order Entry Form]. The fields
in the the [Item Order Details Subform] are
1. [Item Order ID#] - autonumber
2. [Order ID#] - ties to [Main Order Entry Form]
3. [Item]
4. [Quantity]
5. [Total Sales Price]
All five of these field enter data in the Item Order
Details table. The [Total Sales Price] field is set to
lookup a value from the [Price Lookup Query], and the
criteria in the query limits the [Total Sales Price]
lookup to only one value by the following criteria:
1. = [Forms]![Main Order Entry Form]![Item Order Details
Subform]![Item]
2. = [Forms]![Main Order Entry Form]![Item Order Details
Subform]![Quantity]
My problem is that after entering one line item on the
[Item Order Details Subform], the next item returns the
same lookup value from the [Price Lookup Query], instead
of basing the lookup on the current entries for [Item] and
[Quantity] in the subform.
Please Help.
Thank you in advance.
Alex
that is part of the [Main Order Entry Form]. The fields
in the the [Item Order Details Subform] are
1. [Item Order ID#] - autonumber
2. [Order ID#] - ties to [Main Order Entry Form]
3. [Item]
4. [Quantity]
5. [Total Sales Price]
All five of these field enter data in the Item Order
Details table. The [Total Sales Price] field is set to
lookup a value from the [Price Lookup Query], and the
criteria in the query limits the [Total Sales Price]
lookup to only one value by the following criteria:
1. = [Forms]![Main Order Entry Form]![Item Order Details
Subform]![Item]
2. = [Forms]![Main Order Entry Form]![Item Order Details
Subform]![Quantity]
My problem is that after entering one line item on the
[Item Order Details Subform], the next item returns the
same lookup value from the [Price Lookup Query], instead
of basing the lookup on the current entries for [Item] and
[Quantity] in the subform.
Please Help.
Thank you in advance.
Alex