Another question on Access 2000 re: Tab setting

[Abay]

I have a master detail type of multi form and have all the field" tab index
and no" properties set correctly as far as I can see. Yet when I get to the
end of the Master form, I have to press the tab key four time before it goes
to the first field (Settings: Tab Stop = yes, Tab Index = 0) in the Detail
form.

Any help would be much appreciated.

Abay

 

[Ed Robichaud]

Setting the Tab Stop property of the whole TabControl object will turn the
tab stop on/off for all pages (tabs). Don't know why yours is working, but
a work-around would be to use a "[MyFirstControl].SetFocus" statement in
the OnExit event of the last control on your main form.
-Ed

 

[Abay]

Thank you Ed for your reply .. and now to show my complete ignorance ... I
have tried every combination that I know of to reference the field "Model"
on my subform. with no success. The subform is called
"FCldetail_subform" and the field is called "Model"

I am a really a newbie having taught myself a little of Access97 (before
installing the 2000 version) and the best reference I have is VB for
Accsss97 step by step .. its not bad but really only an introduction. I
don't get to use Access nearly as much as I would like, thus my queries here
from time to time. I really appreciate all the help I have received, and
feel bad that I haven't figured this one out

This is the code for the "on exit" event of the last field in the Master
Form.

Private Sub Contact_fax_Exit(Cancel As Integer)

[Cldetail_subform.Model].Setfocus
[FCldetail_subform][Model].Setfocus

End Sub

I have tried other combinations with no luck. Any help would of course be
much appreciated.

Abay

Setting the Tab Stop property of the whole TabControl object will turn the
tab stop on/off for all pages (tabs). Don't know why yours is working,
but a work-around would be to use a "[MyFirstControl].SetFocus" statement
in the OnExit event of the last control on your main form.
-Ed

I have a master detail type of multi form and have all the field" tab
index and no" properties set correctly as far as I can see. Yet when I
get to the end of the Master form, I have to press the tab key four time
before it goes to the first field (Settings: Tab Stop = yes, Tab Index =
0) in the Detail form.

Any help would be much appreciated.

Abay

 

[Ed Robichaud]

Here is a reference for correct syntax with subform and their controls ( I
refer to it frequently)
http://www.mvps.org/access/forms/frm0031.htm

It covers all situations, so you should be able to get the particular name
reference you need.
-Ed

Thank you Ed for your reply .. and now to show my complete ignorance ... I
have tried every combination that I know of to reference the field
"Model" on my subform. with no success. The subform is called
"FCldetail_subform" and the field is called "Model"

I am a really a newbie having taught myself a little of Access97 (before
installing the 2000 version) and the best reference I have is VB for
Accsss97 step by step .. its not bad but really only an introduction. I
don't get to use Access nearly as much as I would like, thus my queries
here from time to time. I really appreciate all the help I have received,
and feel bad that I haven't figured this one out

This is the code for the "on exit" event of the last field in the Master
Form.

Private Sub Contact_fax_Exit(Cancel As Integer)

[Cldetail_subform.Model].Setfocus
[FCldetail_subform][Model].Setfocus

End Sub

I have tried other combinations with no luck. Any help would of course be
much appreciated.

Abay

Setting the Tab Stop property of the whole TabControl object will turn
the tab stop on/off for all pages (tabs). Don't know why yours is
working, but a work-around would be to use a "[MyFirstControl].SetFocus"
statement in the OnExit event of the last control on your main form.
-Ed

I have a master detail type of multi form and have all the field" tab
index and no" properties set correctly as far as I can see. Yet when I
get to the end of the Master form, I have to press the tab key four time
before it goes to the first field (Settings: Tab Stop = yes, Tab Index =
0) in the Detail form.

Any help would be much appreciated.

Abay

 

[Abay]

Thank you again .. I'll try that .. abay

Here is a reference for correct syntax with subform and their controls
( I refer to it frequently)
http://www.mvps.org/access/forms/frm0031.htm

It covers all situations, so you should be able to get the particular name
reference you need.
-Ed

Thank you Ed for your reply .. and now to show my complete ignorance ...
I have tried every combination that I know of to reference the field
"Model" on my subform. with no success. The subform is called
"FCldetail_subform" and the field is called "Model"

I am a really a newbie having taught myself a little of Access97 (before
installing the 2000 version) and the best reference I have is VB for
Accsss97 step by step .. its not bad but really only an introduction. I
don't get to use Access nearly as much as I would like, thus my queries
here from time to time. I really appreciate all the help I have
received, and feel bad that I haven't figured this one out

This is the code for the "on exit" event of the last field in the Master
Form.

Private Sub Contact_fax_Exit(Cancel As Integer)

[Cldetail_subform.Model].Setfocus
[FCldetail_subform][Model].Setfocus

End Sub

I have tried other combinations with no luck. Any help would of course
be much appreciated.

Abay

Setting the Tab Stop property of the whole TabControl object will turn
the tab stop on/off for all pages (tabs). Don't know why yours is
working, but a work-around would be to use a
"[MyFirstControl].SetFocus" statement in the OnExit event of the last
control on your main form.
-Ed

I have a master detail type of multi form and have all the field" tab
index and no" properties set correctly as far as I can see. Yet when I
get to the end of the Master form, I have to press the tab key four time
before it goes to the first field (Settings: Tab Stop = yes, Tab Index =
0) in the Detail form.

Any help would be much appreciated.

Abay