>Hi Chuck
>
>Is this a multi-user situation? Perhaps the value hasn't been entered at the time of the seek. Perhaps another user changed the record before the seek executed. Perhaps the index needs to be rebuilt. As to it working only after the other seek, that makes sense, because if the value is in the index, both should work. It doesn't necessarily indicate that the other type of seeks are making the SEEK() function work.
This is not a multi-user issue - granted the table is on the network and it is opened shared, but I'm the only one in the system. What the program is doing is a part of the data was copied down to a temp table. Later in the program we want to find the data in the real table from the temp table. So I seek the values from the temp table to reposition the live table but the inital SEEK function fails to find the record in the live table.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers