Re-query a combo box Row Source in Datasheet view

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

 

[Klatuu]

Have you tried using the Form Current event to requery the product combo?

 

[Rod Behr]

No, because it didn't seem relevant.

It has done the trick, though. Thank you!