471,092 Members | 1,293 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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 1796

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.