Filtering Combo Box based off another

D

David

I have two combo boxes and I'm trying to have the 2nd combo box filtered by
the first one.

Here is how I have them setup

Combo Box 1
FeildName TOT
Placement Test
ATB
ESL Placement

Combo Box 2
Row 1(ToT1) Row 2(tot2)
English and Reading Placement Test
English Retest Placement Test
Reading Retest Placement Test
ATB Test ATB
ATB Retest ATB
ESL ESL Placement
ESL Retest ESL Placement

So what I'm trying to do is filter combo box 2 row2 with combo box 1. For
example if I select ATB in combo box 1, combo box 2 will list ATB Test, and
ATB Retest.

I was trying a simple applyfilter comand, but no luck.

DoCmd.ApplyFilter , "ToT2 = 'me.combobox1'"

Thank you all and any help would be great.
 

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

Top