I'm redesigning an Access 97 database in 2010. I have a series of yes or no questions. If any of them are answered No, an explanation is required. If the user clicked No, I had a macro that took the user to the explanation field (memo fieldtype), then I used SendKeys {F2}{End} to move the cursor to the end of the field so that the user won't accidentally type over a previous explanation.
I cannot use VBA code because this will eventually be used on a Sharepoint site and Sharepoint sites do not support VBA
Any suggestions? (I'm still on the uphill part of the A2010 learning curve, so even obvious answers are welcomed.)