Filtering a form like excel

[Matt Brown]

Hi all,

I have a form which is set to continous mode.
On each column i am placing a combo box to allow filtering of the data that is displayed on the form.

I have used the following VBA to get the first combo box working;


DoCmd.ApplyFilter , "MANUFACTURER = Forms!frmCcsEditInventoryMain!SelectManufacturer"

This works fine, the problem is how do i set the second combo box to filter the first ones data which is now displayed. The second combo box is for a field called MANUFACTURERS PART NO

I think it needs to look at the recordset but not really sure how to write this.

Any help on this would be good.

Thanks

M<tt

 

[The_Doc_Man]

1. In continuous mode, only one instance of the record is "current" and all others will emulate the appearance of the current record. So if you format the instance of the continuous form, all subsequent instances will (generally) look the same regardless of how appropriate that appearance really is.

2. To find out how to do this, look up the topic "cascading combo boxes" - which is the name used in this column to describe how to handle the situation I think you are describing.

 

[Matt Brown]

Thanks for your reply doc_man

Will have a look at these posts.

cheers

Matt