Acc 97 - Set place/numbering in continuous form by code

[Sabine Oebbecke]

Hi there,

Need some help again ...

I have a continuous form which shows the attendees of a competition as
per their placing in the competition. So, the first record is the
winner, the second record is the 2nd place, etc.

The continuous form's recordsource is an updatable query. The
query/form has got a field 'place' into which the reached place is
entered.

I now want to click on a button in the form header and set the place
for all attendees from the winner to the last place in the continuous
form.

For this I thought the easiest way is to get the line number for each
row source and then 'copy' this value from the line number field into
the field 'place'. I get the numbering with the 'GetLineNumber'
function which works fine, but ... how can I now get the line number
into the field 'place' ... ?

Or is this the wrong approach ... ?

Any help, if possible a bit of code, would be greatly appreciated!

Thanks,

Sabine

[Sabine Oebbecke]

Hurray :-) - found the solution myself with the help of Stephen
Leban's 'Serialize' function.

For all who are interested:

I have the competitors of all competitions with their results listed
in a table, each competitor has got his/her primary key.

I have now created two queries, the first one which gets all
competitors of a specific competition sorted by first place in the
first record, second place in the second record, etc.. The second
query then uses the first query plus the column
Serialize("qryname","key",[key]) to set the records' sequence numbers.

The last step is then an Update query with an Inner Join on the
original table with the competitors, updating the field 'place' with
the sequence number, using the primary key of the competitor.

Thanks, Stephen!