Using Setfocus for VB for Microsoft Access?

Question

I'm making a form right now that has all the circuit outages in a year with many information such as month, circuit name, circuit number, KV, and what not. Theres alot in my form, i want to create a search button named "Find Month" in which the function is that when i click the button, it will prompt up the search field that only searchs for the month and will display all the shortages for that month

Forms!LineOutage!Month.SetFocus

i know thats the code, my table is called LineOutage...i dont know how to bind that into VB code or where to put it


Forms!LineOutage!Month.SetFocus

Answer 1

Place a command button (default name is command1) on your form, then go into the VB editor and place the following code.

Private Sub Command1_Click()
Me.txtMonth.SetFocus
End Sub

When the the command button is clicked the focus will be set to the textbox named txtMonth.