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.




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question