cannot get focused on detail without using the mouse

[Nancy]

I cannot move from header to detail without using the mouse to click on
detail. I have tried using

1. the GOTOCONTROL feature from a field in the header to one in the detail

2. the following event procedure for a GotFocus event as described in a
previous subject posted:

Private Sub txtTransferToDetail_GotFocus()

Me!NameOfFirstControlInDetailSection.SetFocus

End Sub


However, both methods still force me to use the mouse on the detail subform.


Thanks for your help,

 

[Linq Adams via AccessMonster.com]

I think that's simply how Access works, so you'll have to fool it.

Place an unbound textbox in the left, upper corner of the header section

Set it as next one in the tab order from the field you're trying to tab from

Shrink the textbox down in size to a pinpoint

For the field you're trying to tab from

Private Sub FieldTransferringFrom_Exit(Cancel As Integer)
Me!NameOfFirstControlInDetailSection.SetFocus
End Sub

 

[Nancy]

Thanks - but that gets me to my combo box in the detail section. However, I
still have to click on it to be able to type anything in it. I would like
the user to not have to use the mouse at all - just type in the text using
autocomplete.

thanks,
Nancy

 

[Nancy]

I put my form in "one-step" debug mode to check things out. -- I am using
Access 2007.

Using the simple GOTOCONTROL I can go from the header control to the combo
box in the detail section. However, I still need to 'click' on the mouse to
type anything in my combo box. How can I enter text (using autocomplete)
without using the mouse?

Thanks,
Nancy