How to I tab from sub form to main form?

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

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

Robin Chapple said:
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
Click to expand...
Click to expand...
 
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.


Robin Chapple said:
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.

Robin Chapple said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.


Robin Chapple said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top