R
Rod Behr
A form in datasheet view has a column for manufacturer and a column for
product. Each is a combo box.
RowSource for the product combo box is dictated by the contents of the
manufacturer combo box:
SELECT Product FROM Products WHERE Manufacturer = Forms!Form!Manufacturer
How do I get the RowSource property to change and the combobox's drop-down
list to update when moving between rows on the datasheet? I cannot get it to
work on any event (onExit, onGotFocus, etc.).
Sadly, I am bound to Access 2000 for this.
product. Each is a combo box.
RowSource for the product combo box is dictated by the contents of the
manufacturer combo box:
SELECT Product FROM Products WHERE Manufacturer = Forms!Form!Manufacturer
How do I get the RowSource property to change and the combobox's drop-down
list to update when moving between rows on the datasheet? I cannot get it to
work on any event (onExit, onGotFocus, etc.).
Sadly, I am bound to Access 2000 for this.