>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
Is, by any chance, order1.invoice char type?
If so check your SET ANSI setting (and SET EXACT - this is not related to SQL commands)
Also when you use such commands like DELETE and UPDATE I'll suggest you to use [==] not just [=]
That means exactly equal.
Check SET EXACT on the HELP for more description what is the difference.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.