Forms with Tabs

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?
 
B

Bruce M. Thompson

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.
 
J

John Vinson

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.
 

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