I hope this has an easy answer.
I'm trying to open a form that only shows a quantity greater than zero, but I can't get the syntax quite right.
Dim strDocName As String
strDocName = "frmInventory"
DoCmd.OpenForm strDocName, , , "Qty >0"
Since this opens the form and still shows items with "0" quantity, how do I need to word this?
The zero quantities are kept in the database for restocking purposes, so we don't want to delete them, and then have to reenter all of the info when restocked, just enter the new quantity.
Thanks for the help!