468,509 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,509 developers. It's quick & easy.

Copy form control value to table field

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!!
Nov 12 '05 #1
0 1715

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Gene | last post: by
6 posts views Thread by LSemos | last post: by
19 posts views Thread by davidgordon | last post: by
4 posts views Thread by crystal | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.