I have a form, that has 2 buttons to buildcriteria to filter the form according to choices in 2 combo boxes. i.e. in combo box 1 you have a list of clients case status, in combo box 2 you have a list of company representatives.
At the moment, you chose what case status to view (new, offered, etc) and hit button 1. This filters form to show all cases offered etc.
You can also choose a name from the list of company representatives, hit button 2, and it filters the form to show all clients associated with that representative.
Now what I need is 1 button, so you can chose from both combo lists, and end up with a filter that shows all offered cases for 1 representative. In the Access help file they say to concatenate the criteria, only they don't say how to do it!! Anyone know what to do??
Cheers All
At the moment, you chose what case status to view (new, offered, etc) and hit button 1. This filters form to show all cases offered etc.
You can also choose a name from the list of company representatives, hit button 2, and it filters the form to show all clients associated with that representative.
Now what I need is 1 button, so you can chose from both combo lists, and end up with a filter that shows all offered cases for 1 representative. In the Access help file they say to concatenate the criteria, only they don't say how to do it!! Anyone know what to do??
Cheers All