I like to use autokeys to toggle back and forth from form view and datasheet view. This may not help with what you are doing but just in case here is mine. Of couse I am sure you know the macro must be named autokeys
Macro Name Action command
{f9} RunCommand DatasheetView
{f10} RunCommand FormView