Conditions on Combo Boxes

[westcoaststyle]

There is most likely a very easy fix to my problem so I decided to ask you guys. :c)

Ok, I have ComboBox1 and ComboBox2

When I select a value from ComboBox1 I want to change the conditional query on ComboBox2 so that it only displays certain values.

What do I need to do?

Thanks!!!

 

[JoanneM]

HI

1: Go to the query sourcing combo box 2
2: include the field that is going to act as your filter
from comboBox1
3: in this field in the criteria put Forms!frmname!combobox1
(each substituted for the real name of course)

on you form

on the after update of your combobox1 type
me.combobox2.requery
me.refresh

this should give you the desired result

regards

jo