Requery Lookup based on Datasheet Subform

A

Alex

I posted this question in the Forms Programming forum
yesterday, but did not receive a response. I am major
difficulties fixing this issue.

My problem is that the first time I enter a record in a
Datasheet Subform, the Lookup returns the correct value.
However, on subsequent record entries in the Datasheet
Subform use the same lookup criteria as the first record,
instead of the current record's data.

Here is a detailed description of my problem. PLEASE HELP!

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
..
 
Top