The query for the report would be: SELECT * FROM tblBoardOrders WHERE OrderedDate Is Null.
After running the report from VBA code you would put the following:
CurrentDB.Execute "UPDATE tblBoardOrders SET OrderedDate = Date() WHERE OrderedDate is Null"
|