UPDATE:

I downloaded the clients tables and am running the software on my computer with their tables. I go back and forth in the trips, changing things here and there, and I can't repeat the error that happens to them so frequently. We're both running Windows 95 and have computers of a similar speed.

The biggest difference is that their tables are located on a server, while mine are local. Could being on a server be causing this problem?

Thanks,

-Michelle



>Here's the problem: When the code tells the computer to move to the next record, sometimes it doesn't move. This is only happening to one client. That client has a huge table, and I'm thinking that has something to do with it. Also, the problem seems to occur when you try to move to the next (or previous) record after editing the current one. There's no buffering going on; the changes are made straight to the table.
>
>Here's the setup: I have a table of client trips. It is indexed by client number. I have a form that allows you to edit/view these trips. It should let you cycle through the trips by using the "next trip" and "previous trip" buttons.
>
>The code to move to the next trip is as follows:
>
>skip
>if eof()
> go top
> tripnum = 1
>else
> tripnum = tripnum + 1
>endif
>
>(The "tripnum" is because it keeps a counter of which trip you are on. It updates "tripnum" as it should, even when it ignores the skip.)
>
>So that the user cycles through the trips _of that client_ and not _all_ trips in the table, I have tried two methods.
>
>First, I did "set filter to trips.client_num = cnum". This worked in general, but the problem occured frequently.
>
>A friend suggested I use "set key to cnum, cnum" instead. I tried this with high hopes. Nope. Same problem.
>
>There are no errors given and the problem doesn't always happen. The code is simple enough; just tell it to skip to the next. It's just not doing it.
>
>Any ideas?
>
>Thanks in advance,