I have a subform which is used to keep track of open payments. When the payment status changes, the operator chooses the new status from a dropdown box. A Onchange procedure runs and can remove that record from the table if it closes. This sometimes leaves no records in the table.
The problem is that when closing the form, a “No Current Record” dialog box appears. The Microsoft fix of using Movefirst or Movelast won’t work because there are NO records in the recordset currently. SetWarnings does not seem to suppress the dialog box either. It confuses the users and I would like to get rid of the message. Any simple solutions?