keyboard shortcut from header to detail of form

E

elbyc

Is there anyway to use shortcut keys to move from header to detail
section of a form? I have a combo box in the header. When I select a
field from the combo box, it calls an event (procedure pasted below
for reference). The event causes the detail section to jump to the
record pulled from the combo box.

How can I use a shortcut key to move from the header into the detail?

Private Sub Combo38_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Name] = '" & Me![Combo38] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Private Sub Combo41_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Employee ID] = '" & Me![Combo41] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
 
S

storrboy

If there is a particular control you wish to move to, add to the
event... Me!ControlName.SetFocus
 
E

elbyc

If there is a particular control you wish to move to, add to the
event... Me!ControlName.SetFocus

Thanks. For other projects, can I assume that there is no keyboard
shortcut built in to move from header to detail sections?
 
S

storrboy

Thanks. For other projects, can I assume that there is no keyboard
shortcut built in to move from header to detail sections?


Not that I'm aware of. Sorry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top