J
Joseph
I have a table called product and inside there are
Item -PK
Description
Price
I put in the afterupdate event of Item combobox so that it changes to the
description would change to the corresponding 1.
Me.Description = Me.Description.ItemData(Me.Item.ListIndex)
The rowsources for these two comboboxes are as follow
Item.RowSource = SELECT Product.Item FROM Product ORDER BY Item
Description.RowSource = SELECT Product.Description FROM Product ORDER BY Item
It works normally for non-datasheet.. ie like a form with two comboboxes.
But in the datasheet view, when I select eg. A001 in Item, it changes the
whole column in Description into the description corresponding to A001.
Is it possible for me to have just the description in the same row changed
rather than the whole column?
Not sure if I am explaining this clear enough but I am new to access.
Item -PK
Description
Price
I put in the afterupdate event of Item combobox so that it changes to the
description would change to the corresponding 1.
Me.Description = Me.Description.ItemData(Me.Item.ListIndex)
The rowsources for these two comboboxes are as follow
Item.RowSource = SELECT Product.Item FROM Product ORDER BY Item
Description.RowSource = SELECT Product.Description FROM Product ORDER BY Item
It works normally for non-datasheet.. ie like a form with two comboboxes.
But in the datasheet view, when I select eg. A001 in Item, it changes the
whole column in Description into the description corresponding to A001.
Is it possible for me to have just the description in the same row changed
rather than the whole column?
Not sure if I am explaining this clear enough but I am new to access.