Question: 5. Open the Swimmers table in Datasheet View and then create a data macro associated with the Before Change event for the table. The macro
5. Open the Swimmers table in Datasheet View and then create a data macro associated with the Before Change event for the table. The macro checks the LevelID field. If the value in the LevelID field is less than 1, the macro should set the value to 1. If the LevelID field is greater than 6, then the macro should set the value to 6. Save and close the macro and then save and close the Swimmers table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
