My forehead is sore from beating it against the wall. Can anyone
help? I've started drinking again because of this problem!
Setup:
ContestantTbl = table ('one' side)
HorseTbl = table ('many' side)
Race1Qry = query based on BOTH tables
Race1EditorFrm = Main form (display info originating from
ContestantTbl via Race1Qry)
Race1ManagerFrm = Sub-form (display info originating from HorseTbl via
Race1Qry)
Race1ManagerFrm has controls:
RandomTbx = Textbox (control src = random number generator)
DrawTbx = Textbox (control src = row number generator - numbers
rows sequentially)
HoldDrawTbx = Textbox (control src = value of DrawTbx)
The theory of operation:
Query extracts all riders listed as participating in Race 1 (= True in
Race1 field of HorseTbl) Records returned by query are displayed in
Main form (data from ContestantTbl) and sub-form (data from HorseTbl).
Except as noted above, all form controls bound to query fields.
I am trying to copy the sequential row number (AKA 'draw number') back
to the Race1Draw FIELD of the HorseTbl. This draw number is the row
number created by the DrawTbx and mirrored in HoldDrawTbx.
What code could I use (in which event) to copy the form values back
into the table? Is there another (better?) way to do this??
Any help would be truly appreciated. Time for another drink!!