Form Filtering from the ribbon

[tbdel]

Hi All,

I can't figure out Form Filters. Basically I have a load of controls on the form. The first control I select I'm able to click the Filter button on the Ribbon and get shown a load of checkboxes to filter the field on (see capture.png)

On subsequent controls, clicking the Filter button on the ribbon doesn't show the checkboxes for that control (see capture2.png)

I know this definitely used to work, so I'm perplexed as to why it's stopped working.

Many thanks in advance,
Tom

 

[vbaInet]

What sort of controls are these and what sort of data do they hold?

 

[vbaInet]

By controls, I mean what controls on the form are you having problems with?

 

[tbdel]

Hi,

For the example shown, the control is a combo box, which reads a set of default values from a table.

If I filter using the Ribbon control on say "Not Started", I can't then use the Ribbon Filter to filter on other combo boxes on the form (i.e. "Severity" which is also reading some values from a different table).

As I say in my original post, this used to work fine, so I'm not sure what's happened.

 

[tbdel]

Ok, comparing the current version with an older version, when opening the Form and going to Sort & Filter -> Advanced -> Advanced Filter/Sort... in the Table/Query section the "Table" name is "Event Form" in the new version (this is the name of the form), and in the Old version the "Table" name is "Event Data".

Any idea how this might have changed, and more importantly how could I get the new version to read the data from "Event Data" rather than "Event Form"?

P.S. i'm not sure what "Event Data" is... the table that Event Form gets its data from is called EventReport.

 

[tbdel]

Ok, So Event Data was just a query of all the EventReport data.

I'm not sure why this was being used, but I can see the Event Form is a Dynaset Recordset type.

The button on my Main Switchboard is setting an SQL query (like this: sSQL = "SELECT EventReport.* FROM EventReport ORDER BY Event_ID;", and then as part of the Event Form activation the sql is being used to set the recordset:

Set rs = db.OpenRecordset(sSQL, dbOpenDynaset)
.....
Me.RecordSource = sSQL

at this point the combobox filtering still doesn't work.

However, If I go into the Design view of the Form and then back to the Form view, it suddenly starts working.

 

[vbaInet]

Upload a cut down version of your db (just the relevant form, tables and queries linked to the form with random sample data) and I'll have a quick look.

Make sure that the cut down version presents the same problem.