Search form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


Jim said:
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
Click to expand...
automatically when a class is picked from each field eg 1 to 4.
 
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)"

Dan Artuso said:
Hi,
The short answer is yes. Simply re-query the subform on the after update event
of each combo box.
Click to expand...
results of search, can the results be updated
 
Back
Top