C
Commish
I am building a fantasy baseball draft tool for myself. Mostly just to
see if I can do it, and knowing that having the skillset will help me
elsewhere down the road.
I have most of the forms working as I want them. However...
I have a form that is not. I have the form based off of the table
"DraftTracker_All" - and the first field is a ComboBox that works
correctly bringing up fields from the DraftTracker_All table and
bringing up the correct related recordson forms on tabs within the
form. So far so good.
The fields are then populated based on the outcome of an auction of
the player selected from the combo box. I have the combo Box for tea
assignment, position, and salary working correctly. Also good.
However, I have 2 fields that track when in the auction that player
was awarded - the two fields are ROUND and PICK, there is a field
named "Round" in the tabel DraftTracker_All. The value that shows on
the form is populated by the formula
"=1+Int(DLookUp("DraftedPlayers","qry_DraftedPlayers")/13)" which is a
query that I use to count the number of players auctioned off so far.
This calculation will assign the player a round 1st, 2nd, 3rd, etc.
The calculation looks correct. But...
That field doesn't update back to the table - while all of the others
do. When I changed the field "ROUND" from a regular text field to have
that calculation, I must have changed something that I didn't want
to.... what do I need ot change to make the value be saved back to the
table?
see if I can do it, and knowing that having the skillset will help me
elsewhere down the road.
I have most of the forms working as I want them. However...
I have a form that is not. I have the form based off of the table
"DraftTracker_All" - and the first field is a ComboBox that works
correctly bringing up fields from the DraftTracker_All table and
bringing up the correct related recordson forms on tabs within the
form. So far so good.
The fields are then populated based on the outcome of an auction of
the player selected from the combo box. I have the combo Box for tea
assignment, position, and salary working correctly. Also good.
However, I have 2 fields that track when in the auction that player
was awarded - the two fields are ROUND and PICK, there is a field
named "Round" in the tabel DraftTracker_All. The value that shows on
the form is populated by the formula
"=1+Int(DLookUp("DraftedPlayers","qry_DraftedPlayers")/13)" which is a
query that I use to count the number of players auctioned off so far.
This calculation will assign the player a round 1st, 2nd, 3rd, etc.
The calculation looks correct. But...
That field doesn't update back to the table - while all of the others
do. When I changed the field "ROUND" from a regular text field to have
that calculation, I must have changed something that I didn't want
to.... what do I need ot change to make the value be saved back to the
table?