MikeAngelastro
Registered User.
- Local time
- Today, 04:54
- Joined
- Mar 3, 2000
- Messages
- 254
Hi,
I have a Sales Order form with a Line Item subform. One of the fields in the subform has a combo box to be used to lookup the item's location. Each item can have more than one location and there is an Item Location table. The row source query looks at the item number of the current record and passes a recordset containing only the locations of that item. However, this only works on the first item entered into the line item list. After moving past that record and entering a second item, the second combo box returns a recordset of locations for the first item instead of the second item. It doesn't matter how many new items I add to the list, the options in the combo box are limited to the first item entered after opening the form. Even if I enter other orders, the combo box lists only locations belonging to the first item entered into the first sales order. I am using the following notation in the lookup query:
[Forms]![Sales Order]![SOlineitems].[Form]![Item Number]
What am I doing wrong?
Mike
I have a Sales Order form with a Line Item subform. One of the fields in the subform has a combo box to be used to lookup the item's location. Each item can have more than one location and there is an Item Location table. The row source query looks at the item number of the current record and passes a recordset containing only the locations of that item. However, this only works on the first item entered into the line item list. After moving past that record and entering a second item, the second combo box returns a recordset of locations for the first item instead of the second item. It doesn't matter how many new items I add to the list, the options in the combo box are limited to the first item entered after opening the form. Even if I enter other orders, the combo box lists only locations belonging to the first item entered into the first sales order. I am using the following notation in the lookup query:
[Forms]![Sales Order]![SOlineitems].[Form]![Item Number]
What am I doing wrong?
Mike