Need form to open on top of everything.

Misty

Registered User.
Local time
Today, 05:53
Joined
Nov 12, 2003
Messages
45
I use a timer form, With timer set to 1800000 (30 minutes), to open a form every 30 minutes to check for new work orders.

I need the form to open on top of any application that is currently open on my screen.

If I remember correctly, the form has to be set as "Model", but I don't remember how to do that.

TIA




---Start Code---

Private Sub Form_Timer()
RunCommand acCmdAppMaximize
DoCmd.OpenForm "WorkOdersAwaitingApproval"
End Sub

---End Code---
 
If you open the forms properties and select the Other tab you can change Modal to Yes
 

Users who are viewing this thread

Back
Top Bottom