Can a BrowseTo Macro use multiple where conditions to further refine the displayed data?

[cask2010]

Fair warning, I'm quite new to Access so I appreciate any help I can get immensely. Thanks ahead of time. Explaining what I'm trying to do via text seems difficult but here goes nothing:


I'm building a database for an Auto Auction. I'm using a navigation form to allow the user to select which part of the database they're working with. One section of the database [Auctions] is for filtering transactions based on what 'auction date' they took place on, whether the transaction is complete, and other criteria (such as whether the titles have come in or not).

To do this I've created a form called frmAuctions, which has: a combo box [cboSelectAuction], a button to create a new 'auction date', as well as a subform container that holds a form named frmTransactionList. This form has: a button to create a new transaction, as well as a subform container that holds a datasheet [frmTransactionListDS] displaying all of the transactions that took place on a specific 'auction date'.

Here's a snippet to clarify this structure if it helps:

So here's where I'm hitting a wall. I've learned to use the BrowseTo Macro to filter the datasheet (frmTransactionListDS) based on which 'Auction Date' is selected using cboSelectAuction. My problem is that I also have a button (Show Incomplete) on frmTransactionList that, when clicked, I would like to execture a BrowseTo Macro that filters frmTransactionListDS to show only the transactions where "Sale Complete?" = False. How do I make this button run this BrowseTo Macro without the database forgetting which 'auction date' I'm interested in?



Sorry I'm so long winded, I just thought the context would help. Cheers!

[June7]

Don't think a macro can do this. Use VBA. Review http://www.allenbrowne.com/ser-62.html