Forms with Tabs

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a form that has 3 tabs. When I fill in the data in
the last field of the form and hit tab, it updates and
goes to the next form number. What do I need to do so it
doesn't add the record until I hit the add record button?
Also, I have an add record button that I have the tab
index disabled, when I click on the button,how do I make
the focus go to the first tab when I update the record by
pressing the add record button?
 
I have a form that has 3 tabs. When I fill in the data in
the last field of the form and hit tab, it updates and
goes to the next form number. What do I need to do so it
doesn't add the record until I hit the add record button?

Set the form's "Cycle" property (on the "Other" tab in the properties page)
to "Current Record".
Also, I have an add record button that I have the tab
index disabled, when I click on the button,how do I make
the focus go to the first tab when I update the record by
pressing the add record button?

In the form's "On Current" event procedure, you can add a line of code like
this:

Me.tabTest.Pages(0).Setfocus

Be sure to replace "tabTest" with the name of the tab control on your form.
 
What do I need to do so it
doesn't add the record until I hit the add record button?

Set the Form's Cycle property to "same record."
Also, I have an add record button that I have the tab
index disabled, when I click on the button,how do I make
the focus go to the first tab when I update the record by
pressing the add record button?

Put a line of code in the add-record button's click event to SetFocus
to a control on the tab page.
 
Back
Top