I have a subform in datasheet view and am trying to auto select a record when the user clicks on a field.

To accomplish this manually, I can press F2 and then "Shift + Space" and the current record will become selected.

I tried to do a sendkeys on the GotFocus, Enter, On current, etc....but none of them produce the desired results.

I first tried just the F2 to see if it would highlight the field, but that produces inconsistent results. Here is my code

SendKeys "{F2}"
SendKeys "+ " 'The help file is a little vague on how to use the space within the sendkeys action.

Any thoughts would be greatly appreciated.

Thanks,
Mike