Find Function - Multiple Criteria

[Guest]

I have three unbound comboboxes on my form that are used to find records.
One finds a date, another finds a processor name, and the third finds a
company identifier. I need to be able to tie all three together in order to
drill down on certain records. I have already tried a 3 column combobox but
that is not conducive to the number of records that will be in my database -
too much scrolling for the users. I would like to be able to select a date
that will show only those items with that date, and then when I select a
processor, it shows only those records on that date for a particular
processor, and finally when the company identifier has been selected, it
shows only those records on the date selected for the processor selected with
only the company identifier that was selected. Any suggestions or help is
greatly appreciated.

 

[John Vinson]

I have three unbound comboboxes on my form that are used to find records.
One finds a date, another finds a processor name, and the third finds a
company identifier. I need to be able to tie all three together in order to
drill down on certain records. I have already tried a 3 column combobox but
that is not conducive to the number of records that will be in my database -
too much scrolling for the users. I would like to be able to select a date
that will show only those items with that date, and then when I select a
processor, it shows only those records on that date for a particular
processor, and finally when the company identifier has been selected, it
shows only those records on the date selected for the processor selected with
only the company identifier that was selected. Any suggestions or help is
greatly appreciated.

"Dependent Combo Boxes" are a handy technique here. See
http://www.mvps.org/access/frm0028.htm for sample code.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps