Help needed filtering a form using combo boxes

[mea00jmf]

Please help. My inability to achieve this is very frustrating.

I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes.

For example I have fields showing Product ID, Manufacturer ID, Purchase Order number and due date. Each of these fields has a corresponding unbound combo box where users can select values that appear in the table. I need to be able to filter the form based on what is in these combo boxes. I.e. Filler for a product ID to show all purchase orders numbers and due dates relating to that product ID or filter for a manufacturer ID and due date to show all Product IDs and purchase orders relating to that a manufacturer and date.

Ideally this would be achieved by pressing a command button.

The query, table and combo boxes are all built and work fine but I am unable to get the filter to work, I am using Access 97 and am not very familiar with visual basic. Any help would be appreciated.

Thanks.

 

[Kempes]

http://www.access-programmers.co.uk/forums/showthread.php?t=111233

Try this,

although the db example is in acc 2000, the rest might help.

Kempes

 

[mea00jmf]

I think I'm even more confused now!

Based on the example in the link there are a few things I don't understand. I'm sure if I could see the example I would get it but unfortnately we are not all blessed with Access 2000! A few questions.

Do I need to add the criteria to the underlying query? When I do this as per your example I get promted for a parmater when opening the form.

What is the code for the event procedure of the combo boxes? I tried the examples which produced various errors. I do not need the code that makes the labels visible as the lables are next to the boxes and are always there.

Thanks for your help.

 

[Kempes]

Working 97 Version for you to look at.

Hope this helps

Kempes

 

[mea00jmf]

Absolutely excellent. It works as desired.

Thank you very much for your help. Much apriciated.