I'm using a command button to delete files in a table. The "invoice" to delete is entered into the textbox value. The command works and the file is deleted, except it will mark 1 to 5 additional files with it. The additional files deleted are not related to the text1.value.

What am I missing?

In the click command I have the following:

CLOSE DATABASES

USE order1

DELETE from order1;
WHERE thisform.text1.Value = order1.invoice


Thank you,
Dan