changing focus ( in code ) from one form to another

[Swordsman]

How do I change focus from one form to another form

This information would be extremly valuable.


Thanks

 

[Douglas J. Steele]

Forms!NameOfForm.SetFocus

 

[Mark A. Sam]

Use the Openform Method:

Docmd.OpenForm "Formname"

If the form is open, it will give it the focus.

God Bless,

Mark A. Sam

 

[Swordsman]

Douglas,

the method you'v described was what the doctor ordered

much obliged