keyboard shortcut from header to detail of form

  • Thread starter Thread starter elbyc
  • Start date Start date
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
 
If there is a particular control you wish to move to, add to the
event... Me!ControlName.SetFocus
 
If there is a particular control you wish to move to, add to the
event... Me!ControlName.SetFocus
Click to expand...

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

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

Similar Threads

Cobo Box lookup record on a form 1
VB Runtime error 3159 5
Type Mismatch 14
Run time error 3077 1
Code Error 2
Removing Blank Entries From a Combo Box in a Form 1
Combo Box not working right! 3
changing form to not allow edits 2

Back
Top