Bring a Microsoft Access Form to the Front and Set Focus
Question details
Open the frmClock form in the destination Access database and make it ready for use when launched from another database.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user opens the Attendance database and its frmClock form from another Access database.
- Observed behavior
- The destination database may flash in the taskbar while the form does not appear in front, become centered, maximize, or receive focus.
Open the destination Attendance database directly and confirm that frmClock exists and opens normally. Check the form's Pop Up property in Design View, because popup forms can behave differently when selected.
Open frmClock automatically when the Attendance database starts
Use a startup form setting or an AutoExec macro so the destination database opens frmClock itself.
In the Attendance database, select File > Options > Current Database. Under Display Form, select frmClock, then click OK.
If you prefer a macro, select Create > Macro, add an OpenForm action, and set its Form Name to frmClock. Save the macro as AutoExec; use this instead of the Display Form setting to avoid opening the form twice.
Close and reopen the Attendance database, then test launching it from the other database. If its taskbar button flashes, click the button to bring the Access window forward.
Select an open Access form and set its focus
Try these VBA actions when frmClock is already open, particularly if it is not a popup form.
Use WPS Office for Everyday Office Documents
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Its format compatibility can make migration of supported files straightforward, but it does not replace Microsoft Access or fix Access form focus.

Frequently Asked Questions
How do I make frmClock open when the database starts?
In the Attendance database, go to File > Options > Current Database and select frmClock under Display Form. Close and reopen the database to test the setting.
What should I do if the Access taskbar button flashes but the form stays behind?
Click the flashing taskbar button to bring the destination Access window forward. Windows may prevent a separately launched Access instance from taking foreground focus automatically.
Can an AutoExec macro open the form instead of the startup setting?
Yes. Select Create > Macro, add an OpenForm action for frmClock, and save the macro as AutoExec. Avoid using both methods for the same form unless you have a reason to do so.
How can I set focus to a field on frmClock?
After the form opens, run Forms![frmClock]![ControlName].SetFocus in VBA in the destination database, replacing ControlName with the name of an available control.
Does opening frmClock automatically center or maximize it?
No. A startup form setting or AutoExec macro opens the form but does not by itself guarantee centering, maximization, or foreground focus. Check the form's properties and test its behavior in the destination database.




