cascade filtering

[jscriptor09]

Hi

I have a form with several bound textboxes to same table.

I added a filter button next to some of text boxes. Something similar to this

Private Sub cmdFilterProjectID_Click()
DoCmd.GoToControl "Project ID"


DoCmd.RunCommand acCmdFilterMenu
End Sub

Clicking the button will display a filter with check boxes.

The issues I am having is that I want to be able to set the filter on the first text box, then go to the next text box and set another filter ... e.g.; filter the filtered data. However, once I set the first filter, the second filter dialogue always appears as a "text" filter instead of a list of check boxes.

Individually, every filter button shows a list of item with check box for each. It is just when I try to use 2 filters in a row, the second filter dialog does not show the list of check boxes.

Any thought what I am missing?

thanks
Mike

[rpeare]

so the actual control disappears from your form? or you're just having trouble setting up a multi value filter?

if it's the former you may have to look at your code that's hiding/showing your controls
if it's the latter what's the code you're using to apply the filter to your form?

[jscriptor09]

so the actual control disappears from your form? or you're just having trouble setting up a multi value filter?

if it's the former you may have to look at your code that's hiding/showing your controls
if it's the latter what's the code you're using to apply the filter to your form?

Hi

The contol does not disappear. Here is what I am seeing. I click the cmd button, it runs this code:

Private Sub cmdFilterPM_Click()
DoCmd.GoToControl "PM"
DoCmd.RunCommand acCmdFilterMenu
End Sub


and open this dialog. I select a check and select OK. the dialog closes and the filtering works. Now if I press the cmd botton again (the little filter on the left), same dialog re-appear, but now my checked box is no longer checked. Something causing it to forget the previously selected value.

I believe because of this (unchecking previously selected value), the next level filtering is not working as intended.

Any thought what setting in the form controls this? I have another app that works just fine. something is causing this to act dfferently.

thanks

[rpeare]

how about providing a sample of your database and giving explicit directions about what you're doing. Looks like you're using some access right click menu options which I wouldn't use at all in a cascading selection criteria.

[jscriptor09]

Got it figured out. It had to do with the data source setting. If DS is a query, the filter will reset. If the DS is a table, the filter is sticky.

Thanks for your feedback rpeare