Combining multiple Where Conditions in a BrowseTo Argument

[cask2010]

I'm attempting to use the BrowseTo Argument to filter a datasheet embedded on a navigation page. This database is being designed for an Auto Auction, and I want the user to be able to sort the datasheet based on the Date of the Auction, and where the transactions listed in the datasheet are complete or incomplete.

I have a Combo Box set up that allows the user to select an auction date, with an after update macro setting a temporary variable and then a BrowseTo Macro that reopens the datasheet using a specified Where Condition. I've managed to successfully write Where Conditions that work on their own, either filtering just for the Auction Date, or filtering just to show the Incomplete Transactions. My problem is that I don't understand SQL syntax well enough to write a single Where Condition that combines these two together. Ultimately this needs to allow the end user to select an auction date from the Combo Box, and then when they click the Show Incomplete button it needs to BrowseTo the datasheet to show Incomplete Transactions FOR that Auction Date.


And here's a view of my best guess for how the BrowseTo Macro should look.

These two different Where Conditions work perfectly in isolation:
="[AuctionID_FK]= [TempVars]![tmpSelectedAuctionDate]"
="[Sale Complete?]=No"



How do I concatenate them? Please and Thank you So So Much!

[aytee111]

Create a new query in design view
Add both these conditions
Go to SQL view
Copy and paste

[June7]

Make it a single string within two quote marks and remove the other two quote marks as well as all those parens. If you do use the parens, include them within the quote marks.

="[AuctionID_FK]=[TempVars]![tmpSelectedAuctionDate] AND [Sale Complete?]=No"

Advise not to use spaces or punctuation or special characters (underscore only exception) in names. Better would be IsSaleComplete or Is_Sale_Complete.