Rajesh,
Are you absolutely certain that you always have the correct table SELECTed? And that you aren't trying to go to a negative record # after records have been saved? (Only appended but not saved records will have negative record #s).
Barbara
>In one to many form the I receive the following error "Record Is Out Of Range" intermittently. When I ignore it the form continues to run properly.
>
>From has private data session with optimistic buffering. The record number generated are negative. But then the error does not occur to all records. Is there any other way to position the pointer after calculating the column totals.
>
>Rajesh