Re-query a combo box Row Source in Datasheet view

  • Thread starter Thread starter Rod Behr
  • Start date Start date
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.
 
Have you tried using the Form Current event to requery the product combo?
 
No, because it didn't seem relevant.

It has done the trick, though. Thank you!
 
You must log in or register to reply here.

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

Combo box blank due to record source query only selecting records marked as active 1
Make field invisible/inactive depending on combo box in Datasheet 0
Need combo box to refresh when moving to new record 2017 1
How many characters can be displayed in a combo box? 4
ocx calander on a form with subform (datasheet view) 6
Cascading combos in datasheet 0
Retain combo box order 1
Different RowSource for a Combo Box in a Datasheet for each row? 1

Back
Top