Filter forms values with a combobox

juansre

New member
Local time
Yesterday, 16:53
Joined
May 18, 2009
Messages
7
I’ve got a combobox in a form and I would like to filter the records displayed on it by selecting one value on the combo.
I’ve tried many ways:

  • A macro with the “apply filter option”
  • Vba code with recorset filter
And nothing seems to work. Right now, the combo filters the records displayed in the form’s combos, not the records shown in the form. I really don’t know how to do it. Any idea?
I've attached the file as an example.
Thanks in advance for your ideas.
 

Attachments

Your form "frmPlantilla" is linked on the table "tblJugTemp",
but your Combo box is linked on the "tblEq".
What do you want to filter indeed, (which records) ???
 
Last edited:
Your form "frmPlantilla" is linked on the table "tblJugTemp",
but your Combo box is linked on the "tblEq".
What do you want to filter indeed, (which records) ???

Hi!! and thanks for the reply
I'd like to filter the frmPlantilla data by "idEq" column, so the combo fix the value of idEq to filter tblJugTemp by that value.
Hope i had explain it correctly...
 
Hello jsantos!
Here it is, (attachment, zip).
Open form and try. Look at VBA.
Addapt it as you need.
 

Attachments

Hi Stef.
Simply perfect...I've made a little tweak to filter by two combos, and still going perfect!!!
Thanks a lot for your kind an quick reply.
 

Users who are viewing this thread

Back
Top Bottom