Search form

[Guest]

I have 4 search fields class 1 to 4 on the main form and a subform with results of search, can the results be updated automatically when a class is picked from each field eg 1 to 4

class 1 drop down list PICKED motors, list appears with suppliers of motor
AN
class 2 drop down list PICKED pulleys, list appears with suppliers of motors and pulley
and so on any help on this matter would be great, still learning

 

[Dan Artuso]

Hi,
The short answer is yes. Simply re-query the subform on the after update event
of each combo box.

--
HTH
Dan Artuso, Access MVP

I have 4 search fields class 1 to 4 on the main form and a subform with results of search, can the results be updated

automatically when a class is picked from each field eg 1 to 4.

 

[Michael San Filippo]

you can also just requery the combobox instead of the whole form.

or you can change the rowsource by using.

docmd.combo2.rowsource = "(SQL statement goes here)"

Hi,
The short answer is yes. Simply re-query the subform on the after update event
of each combo box.

results of search, can the results be updated