How to I tab from sub form to main form?

[Robin Chapple]

I have a main form with member details and a sub form with history.

I have made the tab order so that tab stops 20 and 21 are on a sub
form, (actually 1 and 2 on that form).

How do I make the next tab stop the next fields on the main form?

Thanks,

Robin Chapple

 

[Guest]

From the last field in the subform, set a focus to the reuired field in the
main form.
e.g
In the "lost focus" property of the last field on the subform, put the code
Forms![MainFormName].[FieldNameToGetFocus].setfocus.

 

[Robin Chapple]

Thanks,

I understand the logic but I have done something wrong.

Here is your code with my form name and field name:

Forms![frmMembers].[Notes].setfocus

I get an error message:

""Can't find macro "Forms!frommembers"

What did I miss?

Thanks again

From the last field in the subform, set a focus to the reuired field in the
main form.
e.g
In the "lost focus" property of the last field on the subform, put the code
Forms![MainFormName].[FieldNameToGetFocus].setfocus.

I have a main form with member details and a sub form with history.

I have made th tab order so that tab stops 20 and 21 are on a sub
form, (actually 1 and 2 on that form).

How do I make the next tab stop the next fields on the main form?

Thanks,

Robin Chapple

 

[Guest]

You probably put the code in the line of the property, instead in that
property you can choose three options one of them is code, select the code
and enter it as VBA.
When you put something in the line of the property the application look for
a macro.

Thanks,

I understand the logic but I have done something wrong.

Here is your code with my form name and field name:

Forms![frmMembers].[Notes].setfocus

I get an error message:

""Can't find macro "Forms!frommembers"

What did I miss?

Thanks again

From the last field in the subform, set a focus to the reuired field in the
main form.
e.g
In the "lost focus" property of the last field on the subform, put the code
Forms![MainFormName].[FieldNameToGetFocus].setfocus.

I have a main form with member details and a sub form with history.

I have made th tab order so that tab stops 20 and 21 are on a sub
form, (actually 1 and 2 on that form).

How do I make the next tab stop the next fields on the main form?

Thanks,

Robin Chapple

 

[Robin Chapple]

Thanks,

You were right.

You probably put the code in the line of the property, instead in that
property you can choose three options one of them is code, select the code
and enter it as VBA.
When you put something in the line of the property the application look for
a macro.

Thanks,

I understand the logic but I have done something wrong.

Here is your code with my form name and field name:

Forms![frmMembers].[Notes].setfocus

I get an error message:

""Can't find macro "Forms!frommembers"

What did I miss?

Thanks again

From the last field in the subform, set a focus to the reuired field in the
main form.
e.g
In the "lost focus" property of the last field on the subform, put the code
Forms![MainFormName].[FieldNameToGetFocus].setfocus.

:

I have a main form with member details and a sub form with history.

I have made th tab order so that tab stops 20 and 21 are on a sub
form, (actually 1 and 2 on that form).

How do I make the next tab stop the next fields on the main form?

Thanks,

Robin Chapple