filtering of Records...

[Hellfire]

Hi All,

Can anyone please help, I'm gonna try and explain this as clearly as I possibly can...

I have a table (tblProducts) with only two fields, Product ID and Product Discription. On a form that my users use to enter new deliveries, they have a combo-box linked to the table. (in other words, they can only choose an option from the list, the list can be "edited" by adding/removing records from the table, tblProducts)

I want another form (based on frmStock) used to display ALL the records entered in date order. (It doesn't matter if it is different products, I want it to be that way.

Then the problem...I want to have another form, on this form should be the same combo-box that pics up it's values from tblProducts. My users should choose one product from the list, click the OK-button, and that must then filter frmStock, to display only the entries under that specific product.

I can create different filters for all the products, but I would like to cut out the time it takes. As we might be adding new products to tblProducts, I would not like to create a new query every time I add a product.

Is there a way of creting a "blank" query and the value for the query is set from the combo-box. The results from the query displayed in a form. (Not in datasheet view)

Please help if you can. Even if you can just point me in the right direction!!

Thanks,
H

 

[Hellfire]

Hi All,

Just trying to get my post to the top f the list again!! ;-)

Can anyone see if they can suggest anything for my problem?

Thanks,
H

 

[Dave Eyley]

If the table (tblProducts) is only used for the RowSource for the Combo, why not make the RowSource for the Combo the table that holds all the details for all of the products....

This way the Combo list will be dynamic i.e. it will grow/shrink depending on the records in the main table. Remember make the list show unique records only.

The only problem with this method is that it can get messy if users mis-spell a product name and then it gets input again using a different spelling and so on....how you deal with that is up to you....

HTH

Dave Eyley