I'm realy starting to get frustrated at myself, so I know you have to be a little bothered. It turns out that the Invoice Number on the screen is not the invoice ID. I knew this but forgot. The ID is 2420.

However, that should not have effected the stuff in the forms that was not hard coded. The correct record was displayed so the ID should have been right.

I went back to the earlier code you told me to try in the commnand window with the correct ID.

lnInvoice_ID = 2420
Select * from InvoiceDetail Where Invoice_ID = lnInvoice_ID ;
into cursor InvLinesCursor
browse

That pulls up the InvLinesCursor successfully and shows me the one record. This invoice has only one product.
It does have the correct produt ID (94).

I have gone back to the command button that had the ID hard coded and it updates the product file OK and I get my message box telling me it should be updating and the Tally is 1.

Sorry for sending you down the wrong path.


>In the command window, you needed do each one separately, or you could highlight all three commands (4 lines?) and then press enter.
>
>So the query does not work. Let's eliminate a variable (try in command window)
>
>

>Select * from InvoiceDetail Where Invoice_ID = 31984
>

>
>Your results will pop right up in a browse window...does it work? If it doesn't, you need to look at the invoiceDetail table and make sure it has data for this invoice_ID in it.
>
>
>>Sorry guy, I lied to you earlier.
>>I see now that I did a cut and past of all your earlier commands into the command window and it only performed the last line that was "Browse". What I saw was the Product file. As soone as I noticed that the Product_ID was right, I thought all the code ran. The pointer was there because of the IndexSeek command I tried on the Product file that came back true put it there.
>>
>>Now that I do the three lines of code one at a time I get the InvLinesCursor table open and it is blank. New hmmmm.
>>
>>Based on that, should I still try this code?
>>