Command Click (Tab)?

Question

Hello Everyone,

I currently have a button that requerys, closes, & opens a form. but I need it to go to the next tab stop before it closes what shoudl I add to my codding below to make it Tab, requery, close, & open?


Private Sub Command39_Click()

DoCmd.Requery

DoCmd.Close
DoCmd.OpenForm "area 93 master list"
Forms![area 93 master list]!List0.Requery

End Sub

Answer 1

Use the Sendkeys function to insert the tab wherever necessary:

Private Sub Command39_Click()
sendkeys "{TAB}"
DoCmd.Requery

DoCmd.Close
DoCmd.OpenForm "area 93 master list"
Forms![area 93 master list]!List0.Requery

End Sub