>Actually, the record pointer is being moved to the temporary internal invoice number. If I append a record, the new record does not show up in the grid. Rather, the prior invoice shows up. The appended record is there and the current invoices totals are accurate. For some reason the grid doesn't get refreshed even though a refresh is hard coded in.
>
>I'm perplexed.
How are you defining the relationship between the records in the grid and the invoice number? I use a parameterized view for something like this, in which case, updating the parameter and issuing a REQUERY() against the grid's recordsource should handle the process. If you're going up against a table, you may have to issue a seek to move the record pointer in the grid to the first matching record, or any of a dozen different strategies that might work. Without knowing how you maintain the relationship between the invoice number and the line items displayed in the grid, it's tough to answer...