dynamically compare value against values in a query

[Kyosa]

basically i'm trying to dynamically assign a controlsoure to a specific field based on a value selected from an unbound combo box(Combo4).
i have a query set up that contains all my invoice exceptions and i'm trying to basically check to see if the value i select in Combo4 is in the exception query. i've tried using dlookup etc but can get it to work. is there something simple i'm missing?

thanks in advance

 

[jerasi]

I think what you need to do is:
1. get the value from the conbo box (me.cboBox.value)
2. use the FindFirst function to search for the value above in your query.

Regards.
Jerasi.