Using the setFocus command on two forms at the same time

[Lou_Reed]

Here is the text that describes how to use the setfocus command.

You can have VBA automatically move the cursor to any control on your form.
This can be handy when your code can anticipate where the user is most likely
to type next. You can have VBA position the cursor to the appropriate control
automatically so that the user can just keep typing and not move the cursor
on his own.

The same technique also lets you avoid error messages caused by trying to
disable (or hide or lock) the control that currently has the focus. The VBA
syntax for setting the focus to a specific control is
controlName
.                                                               ControlName.SetFocus
where 

controlName is the name of the control to which you want to move
the cursor. For example, the following statement moves the cursor to a control
named 
CCType on the form:
                                                               [CCType].SetFocus

What it does not tell you is how the command changes when the control is on a second form. Say you have two forms open and the cursor is at the bottom of the second one and you want it to go to the top of the first one.

How is the command

[CCType].SetFocus

changed?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

Try

Forms!SecondFormName.DesiredControlName.SetFocus

[ranman256]

2 separate forms,
or
1 master form,with a child form?

[Lou_Reed]

I am back on working on this and I think that maybe a master form and a child form might be the way to go. Is there any info written on this? I am unsure as to how to create the set.

Respectfully,

Lou Reed

[Bulzie]

You have a main form based on a main table and a subform within that is based on the child table. They are usually linked by the Key field on the Main form and a Foreign key(same field) on the child table. This field would go into the LinkMaster and LinkChild properties on the Subform.

But as pbaldy said, I believe if you want to set focus on a field in another form, use the full path or the form as he listed.