|
Subject:
|
Datasheet View Auto Highlight a Row
|
|
Posted By:
|
Dataman
|
Post Date:
|
2/15/2004 10:16:09 AM
|
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
|
|
