Re-query a combo box Row Source in Datasheet view

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.
 

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

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Cascading combo problem 6
using one combo box to determine content of a second combo box 2
how do i use one combo box to determine the content of a second combo box? 3
ocx calander on a form with subform (datasheet view) 6
Cascading Comboboxes in Datasheet View 0

Top