The user enters FROM - THROUGH locations for inputting physical inventory count. Using a view, my app produces a grid of the items contained within those parameters. If there are any write-ins to be entered, the user clicks on a button and another window pops up for adding records. For this window, I am, of course, using the table (optimistic table-buffered) for the additions. When the user closes the add window, I REQUERY the p-view. Works great on my stand-alone machine. However, on the network, the new records show up in the view, but Quantity and Retail Price both = 0. If the user changes to another set of location parameters and comes back to the first one, all the data is there.

Any ideas what to do? It's like the missing data is stuck in RAM someplace and is being ignored by the query. Any suggestions would be deeply appreciated.

TIA,
John