Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Need to set a filter
I have a situation where i need to be able to set a filter on my form and can't figure out how to do it, newbie that I am.
I have a data combo box of department numbers created from an sql statement in the recordsource property. I also have a listbox of subdepartment numbers created by an sql statement in it's recordsource property. The information in both these objects comes from different tables which share one key field, the department number. I want the listbox of subdepartment numbers to be filtered and to refresh itself based on the department number selected in the data combo box.
Any comments that could point me in the right direction would be appreciated.
Marie
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement