if you point the where part of the Query to the combo box in the form
then when run the query it will read the combo box
The Criteria of the query should look something like
a tick i use is open the form in question then right click in in the Criteria of the query and click the Build .. just drill down to what you want.
then to give it a brain
Private Sub CBOMainList_AfterUpdate()
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.