A
Aaron WOLSKI
Hi Guys,
I have a rather frustrating problem and would appreciate your ideas. I
have a form with the fields Company, Item and Qty. Company and Item are
both combo boxes such that the user must selected from a list of known
companies and then select an item that the particular company supplies.
Therefore, the OnUpdate event of Company changes the row source of Item to
only show the relevant Items from a catalogue table. I am displaying the
information as a datasheet so that it is easy to insert many items for a
particular project.
My problem is that whenever the Company field is changed, thus changing
the row source in the Item field, because the ItemID of the previous items
may no longer be in the result set of the new statement the description
field disappears. When Company is changed back, all its associated Items
become visable again but the others disappear.
Once the Item has been set, is there a way to freeze the text so that is
not affected by the change of row source.
Cheers,
Aaron Wolski
I have a rather frustrating problem and would appreciate your ideas. I
have a form with the fields Company, Item and Qty. Company and Item are
both combo boxes such that the user must selected from a list of known
companies and then select an item that the particular company supplies.
Therefore, the OnUpdate event of Company changes the row source of Item to
only show the relevant Items from a catalogue table. I am displaying the
information as a datasheet so that it is easy to insert many items for a
particular project.
My problem is that whenever the Company field is changed, thus changing
the row source in the Item field, because the ItemID of the previous items
may no longer be in the result set of the new statement the description
field disappears. When Company is changed back, all its associated Items
become visable again but the others disappear.
Once the Item has been set, is there a way to freeze the text so that is
not affected by the change of row source.
Cheers,
Aaron Wolski