ajetrumpet
Banned
- Local time
- Today, 12:45
- Joined
- Jun 22, 2007
- Messages
- 5,638
Shapman,
The attached ZIP works the way in which you asked about, all except for the SubStatus combo box. I'm afraid your value list for the SubStatus combo box comes from the values in your "SUBstatus" table, not the "tblSTATUS", which is the one you have joined in the underlying query. Thus, until you either change the values for the substatus combo box rowsource, OR create an appropriate relationship between the contactdetails table and the substatus table, you will not be able to include the substatus combo box in your search.
Notice the way the query is written. It is an exact replica of the format in Post #4.
The attached ZIP works the way in which you asked about, all except for the SubStatus combo box. I'm afraid your value list for the SubStatus combo box comes from the values in your "SUBstatus" table, not the "tblSTATUS", which is the one you have joined in the underlying query. Thus, until you either change the values for the substatus combo box rowsource, OR create an appropriate relationship between the contactdetails table and the substatus table, you will not be able to include the substatus combo box in your search.
Notice the way the query is written. It is an exact replica of the format in Post #4.