E
efandango
Primary Objective:
I have a form which is linked to a series of records which are street names.
The purpose of the form is to allow the user to guess/memorise the order that
the streets appear. When the user first goes to the form tab, The form's
field boxes are blank. The user has to then decide which Address will appear
and then hit the button to discover if he was correct, as each answer is
revealed.
For this purpose, I want the user to be able to hit a reveal button where
each new street (record) is revealed in ascending order on a continous form.
Secondary Objective:
Each time the user presses the Reveal button, I want to be able to measure
the difference in seconds between each button push (record request).
Some constraints:
Each Recordset is a subset based on a Master Form/PK called Run_No.
Each Recordset will differ in number of Addresses (hence a continous form)
The data of the table for the Reveal Form is: tbl_Waypoints_Reveal_Target
Run_waypoint_List_ID AutoNumber,rPK
Run_No Number,linked to Master PK
Run_waypoint Text, Address field
Run_Direction Text, Address field
Timer_pressed Timefield, seconds
Elapsed Time Timefield, seconds
OrderSeq Number
This is how the data looks on the form.
Run_No Run_waypoint_List_ID Run_waypoint Run_Direction Timer_pressed Elapsed
1 365 Main Street L on L 10:39:45 03
1 366 South Road R 10:39:46 01
1 367 East Road L 10:39:46 04
I have a form which is linked to a series of records which are street names.
The purpose of the form is to allow the user to guess/memorise the order that
the streets appear. When the user first goes to the form tab, The form's
field boxes are blank. The user has to then decide which Address will appear
and then hit the button to discover if he was correct, as each answer is
revealed.
For this purpose, I want the user to be able to hit a reveal button where
each new street (record) is revealed in ascending order on a continous form.
Secondary Objective:
Each time the user presses the Reveal button, I want to be able to measure
the difference in seconds between each button push (record request).
Some constraints:
Each Recordset is a subset based on a Master Form/PK called Run_No.
Each Recordset will differ in number of Addresses (hence a continous form)
The data of the table for the Reveal Form is: tbl_Waypoints_Reveal_Target
Run_waypoint_List_ID AutoNumber,rPK
Run_No Number,linked to Master PK
Run_waypoint Text, Address field
Run_Direction Text, Address field
Timer_pressed Timefield, seconds
Elapsed Time Timefield, seconds
OrderSeq Number
This is how the data looks on the form.
Run_No Run_waypoint_List_ID Run_waypoint Run_Direction Timer_pressed Elapsed
1 365 Main Street L on L 10:39:45 03
1 366 South Road R 10:39:46 01
1 367 East Road L 10:39:46 04