Tab Control problem

[WW]

I have a form that is broken down into 3 Tab Controls. If I am in the first
sheet(Tab) and I am tabbing through the various controls, when I get to the
end I will go to the next record instead of the next sheet(Tab) of that
record. There must be a setting that controls this but I can't figure it
out. Thanks in advance for your help.

[Deano]

WW wrote:

I have a form that is broken down into 3 Tab Controls. If I am in
the first sheet(Tab) and I am tabbing through the various controls,
when I get to the end I will go to the next record instead of the
next sheet(Tab) of that record. There must be a setting that
controls this but I can't figure it out. Thanks in advance for your
help.

Maybe change the Cycle property of the form to Current Record?

[Trevor Best]

On Tue, 25 Nov 2003 17:15:34 -0500 in comp.databases.ms-access, "WW"
<a> wrote:

I have a form that is broken down into 3 Tab Controls. If I am in the first
sheet(Tab) and I am tabbing through the various controls, when I get to the
end I will go to the next record instead of the next sheet(Tab) of that
record. There must be a setting that controls this but I can't figure it
out. Thanks in advance for your help.

On the last control on the first and second pages:

Sub MyTextBox_Exit()
MyTabControl.Value = MyTabControl.Value + 1
End Sub

Substitute names for ones that reflect yours.

--
A)bort, R)etry, I)nfluence with large hammer.