My form has a list box and plenty of fields of all types. The listbox controls the record nav as does prev and next cmd buttons.
Problem: When the user clicks the new button all fields are cleared out, however, the current record which was just in the fields is updated to a bunch of empty fields.

How can I get around this?