I have an Access 2010 form based on a table (tblPurchaseReview)
This table is a list of items to be review for purchasing. There is a check box for each line to indicate that it need to be purchased.
The problem is that the same item may be listed multiple times. We may check all or none of the lines. However, if at least one line has a check I want to be able to filter all of the ID_ITEM for the entire form, causing all ID_ITEMS to filter out if there is at one one check.
I have a query (qryFilterCheck) to find the unique ID_ITEMs that need to be filtered.
I have tried the following code, which is not working.
Private Sub cmdFilterChecked_Click()
'Move focus to an open field
'Hide the Filter Bittpm
Me.cmdFilterChecked.Visible = False
'Unhide the Unfilter Button
Me.cmdShowAll.Visible = True