Help with "pointing" to a specific record.

[Dan-A]

Hi All,

There is probably an easy way to do this but i can't think of it.

I have a db with dates all sorted by ascending date order.

When i create a new record (enter a new date) i want to re-sort

my db and point to the newly created record.

(Which might not be the most recent date ie: Goto last record does not work)

I tried doing a find, but that only gives me one record in the found set

so the user can't navigate to other records.

I thought of comparing my "new" date with the first & last date to

determine if i should use a loop that goes to next record from record one OR

start at the end and loop to previous record with exit when newDate matches

the record's date.

Is there a better way?

Thanks

--Dan

[Mike D.]

Dan,

There are several ways to accomplish this. The easiest may be to have your new record script switch to Form View and then create the new record. When data entry is done, you can switch back to the sorted list view.

HTH, Mike

[Fitch]

Since you're going to have to use a script for this, you could set the current record's serial number (you do have one, I hope) into a global field. Then, after your sort, go to related record (global::serial).

[Dan-A]

Thank you all

I knew it was easy, just could not get my brain in gear!!!

Yes Tom i have a serial number & i will use it to go to the record i just created.

--Dan