This is a WAG, but if you are dealing with buffered tables or views, the report (and some of the functions in the app) may be looking at the source tables while the new data is still uncommitted.
>In an application I am now responsible for (written mostly by some one else). The user has reported the following
>problem.
>
>1. Open ordering form. Enter order and systems says there the item is not available (but they are holding it in
> their hand so it obviouly is).
>
>2. Open inventory form. Up the amount available field.
>
>3. Close inventory form which returns them to ordering form.
>
>4. Print copy of order for customer. Problem is name on form is that of person for previous order.
>
>Forms have data sesions but they are not private. Name is gotten by looking it up in an accounts table via the
>account number.
>
>Any help in finding and fixing this problem would be appreciated.
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05