View Full Version : list or combo box to act as a filter


slug1029
10-06-2000, 09:15 AM
Some help on this one would be nice.
I would like to be able to filter my results based on a selection in a combo box.

For example, I have the main form that shows data for all entries in the database and I would like a user to be able to filter the list based on different fields.

An Example:
Main form has fields CustName, CustCity, CustProduct. I need a combo box that when CustName is selected, it filter the form for all records based on that customer name. I would like to be able to do this for each of those three fields

Chris

Jack Cowley
10-06-2000, 05:04 PM
This article may give you some insight into how you can solve your problem....
http://support.microsoft.com/support/kb/articles/Q135/5/46.asp?LN=EN-US&SD=gn&FR=0

HTH,
Jack