M
MikeB
I have a form to record the results of each chess game. There is a
white player and a Black player. On the form, the players simply note
whether the Result was White, Black or Draw.
On my form I've designed a combo box with White, Black and Draw as the
options.
When the combobox is changed, then I wrote some code to put the actual
scores into the Game record.
Unfortunately, if I don't actually click and reselect a value in the
combo box, then the code isn't driven, so if two consecutive White
wins need to be recorded, I still have to click the combo box.
I'd like to know what event at "add record" time I can use to look at
the combo box and update the score fields in the record.
Also, when browsing the database, the combo box field doesn't display
the results. So I would also like to know how to, on each new record
displayed, to look at the score and set the combo box accordingly.
Also, will this be sufficient for the first record or do I have to
also code the form open event to have the value displayed for the
initial record?
Thanks.
white player and a Black player. On the form, the players simply note
whether the Result was White, Black or Draw.
On my form I've designed a combo box with White, Black and Draw as the
options.
When the combobox is changed, then I wrote some code to put the actual
scores into the Game record.
Unfortunately, if I don't actually click and reselect a value in the
combo box, then the code isn't driven, so if two consecutive White
wins need to be recorded, I still have to click the combo box.
I'd like to know what event at "add record" time I can use to look at
the combo box and update the score fields in the record.
Also, when browsing the database, the combo box field doesn't display
the results. So I would also like to know how to, on each new record
displayed, to look at the score and set the combo box accordingly.
Also, will this be sufficient for the first record or do I have to
also code the form open event to have the value displayed for the
initial record?
Thanks.