Using Filter on a Table

[choward]

Hi Guys,

I was hoping to be able to have a drop down box to filter records in a table without going via a query. The reason being is that when you use a query to filter the records in a table, you cannot add to the dataset in table view.

is there a way of using a combo box to invoke the filters at the top of the table?

Thanks,

Chris

 

[heedaf]

If you use the drop down box in the form based on a filtered query then have the control sorce of the drop down box linked to the table that might work. You might have to temporarily dublicate the table. If you know VB it is much easier.

 

[choward]

Thanks Heedaf. I dont fully understand your suggestion though. I haven't programmed in VB using access before - i'm more of a C programmer so this is quite new to me.

I had noticed that in Access (2007 at least), on top of each table column is a small button that lets you filter records. If you use that filtering system, you can still add records to the table. but if i use a form based on a filtered query, i cannot. Is there any way of using a combo box to invoke the built in filtering of Access 2007?

Thanks,

Chris

 

[choward]

If anyone else had this same problem, the solution is as follows:

In the after update control of a controlling combobox (calld comLoc in this case):

Forms![RAP Manager Interface]![RAP Courses Locked subform].Form.Filter = "Location = [comLoc]"
Forms![RAP Manager Interface]![RAP Courses Locked subform].Form.FilterOn = True