Copy calculated values to a table

[gary b]

I have searched... and read... and experimented... but I
cannot get this to work. Is this, Mr Phelps, my 'mission
impossible'?

tblContestant - table with contestant demographics (name,
address, etc)
tblHorse - VERY DETAILED info: horse name, checkboxes to
show entry in one or more of 12 races, a field to record
the contestant's race time, and the contestant's position
in the 'running order' (runs second... or seventh... or
twenty-first... etc).

Relationship: 1 to Many - a rider may have multiple horses
and may enter each horse in more than one event.

frmRace1editor - form displaying demographic info for
records selected/queried from tblContestant
frmRace1manager - form displaying DETAIL information (from
same query driving frmRace1editor) BUT FORM IS EMBEDDED in
frmRace1editor as subform

I use a query (qryRace1) to extract records from both
related tables AND to generate a random number for each
returned record. The query results are sorted based on the
random number.

The results of the above query are displayed in the
form/subform. Additionally, I have used Stephan
Lebans' 'serialize' function to number each row displayed
in the subform (named frmRace1manager) embedded in
frmRace1editor. These sequential values (row numbers)
represent the 'running order' of the race.

HOW can I get the row number for each record displayed in
the subform copied into the tblHorse in the field
Race1Draw?? Any help would be appreciated! I've started
drinkin' again because of this problem!

 

[TC]

Not to answer your question, but- if you have 12 seperate yes/no fields in
tblHorse to show entry in up to 12 races, your database is definitely not
"normalized" properly. This will cause you endless problems down the track
(to coin a phrase!). Start here for a dry, but instructive read:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC