Focus on another form

[jwigh]

When I open a form fAccepted should under some conditions another form fChanges open. With access 2000 I use this code.

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0, 0, 15300, 10000
If DMax("RevDate", "tVersion&quot >= DLookup("LastAccess", "tUsers", "User='" & Forms!fInloggning!tbUser & "'&quot Then
DoCmd.OpenForm "fChanges"
End If
End Sub


If the condititon is meet, fChanges opens but behind fAccepted. I have tried Forms!fChanges!btOk.SetFocus after DoCmd.OpenForm... without any difference.

I have done things like this before without any problems.

 

[Glohamar]

Have you tried Me.btOk.SetFocus on the Form_Open event of fChanges form?

See if that works.

Dave

 

[RoyVidar]

Hi!

Just guessing here, but is the current form (fAccepted) either opened with the acDialog argument, or does it have it's modal/popup properties set to yes?

If so, you might get a better result opening the changes form with acdialog.

[tt]DoCmd.OpenForm "fChanges",,,,,acDialog[/tt]

HTH Roy-Vidar

 

[jwigh]

The Pop-up property for the form fChanges were set to No. When changed to Yes it worked ok.

Thanks anyway